<

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.


SQL Left Join Syntax


SELECT table1.column1, table2.column2....  
FROM table1   
LEFTJOIN table2  
ON table1.column_field = table2.column_field;  

















© copyright 2017-2022 Completedone pvt ltd.