Answers for "sql join select certain columns"

SQL

1

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 "sql join select certain columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#