SELECT * FROM table1 INNER JOIN table2 USING (table1_id);
SELECT * FROM table1 INNER JOIN table2 ON (table2.table1_id = table1.id);