1SELECT
2 t1.* -- All columns from table1
3 ,
4 t2.columnName -- Just that column from table2
5 ,
6 t3.columnName -- And just that column from table3
7
8FROM
9 table1 AS t1
10
11 INNER JOIN table2 as t2
12 ON t1.id = t2.table1_id
13
14 INNER JOIN table3 AS t3
15 ON t1.id = t3.table1_id
16