sql inner join sprcific columns
snippet in sql

sql inner join sprcific columns

user6087

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