SELECT * FROM table1 INNER JOIN table2 ON table1.id=table2.id INNER JOIN table3 ON table2.id=table3.id;