or download this
mysql> select a.id as a_id, a.title as a_title, b.id as b_id, b.title
+as b_title from test a inner join test2 b using(id);
+------+---------+------+---------+
...
| 2 | second | 2 | second |
+------+---------+------+---------+
2 rows in set (0.00 sec)