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);
+------+---------+------+---------+
| a_id | a_title | b_id | b_title |
+------+---------+------+---------+
|    1 | first   |    1 | first   |
|    2 | second  |    2 | second  |
+------+---------+------+---------+
2 rows in set (0.00 sec)