Javatpoint Logo
Javatpoint Logo

SQL LEFT JOIN

The SQL left join returns all the values from the left table and it also includes matching values from right table, if there are no matching join value it returns NULL.

BASIC SYNTAX FOR LEFT JOIN:

let us take two tables in this example to elaborate all the things:

CUSTOMER TABLE:

IDNAMEAGESALARY
1ARYAN5156000
2AROHI2125000
3VINEET2431000
4AJEET2332000
5RAVI2342000

This is second table

ORDER TABLE:

O_IDDATECUSTOMER_IDAMOUNT
00120-01-201223000
00212-02-201222000
00322-03-201234000
00411-04-201245000

join these two tables with LEFT JOIN:

This will produce the following result:

IDNAMEAMOUNTDATE
1ARYANNULLNULL
2AROHI300020-01-2012
2AROHI200012-02-2012
3VINEET400022-03-2012
4AJEET500011-04-2012
5RAVINULLNULL
Next TopicSQL Right Join




Please Share

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials