Answers for "postgres inner join without certain columns"

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

Posted by: Guest on July-02-2020

Code answers related to "postgres inner join without certain columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres inner join without certain columns"

Code answers related to "postgres inner join without certain columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "postgres inner join without certain columns"

Code answers related to "postgres inner join without certain columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us