how to get a field from specific table sql join code example
Example: 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