Sql inner join sprcific columns

This article is tagged with: Sql inner join sprcific columns and mysql

sql inner join sprcific columns

SELECT
t1.* -- All columns from table1
,
t2.columnName -- Just that column from table2
,
t3.columnName -- And just that column from table3
FROM
table1 AS t1
INNER JOIN table2 as t2
ON t1.id = t2.table1_id
INNER JOIN table3 AS t3
ON t1.id = t3.table1_id

This article is tagged with: Sql inner join sprcific columns and mysql