Left Join is used to join two tables and it return all rows from table 1 and matching rows from table 2. The result is NULL for unmatched rows for table 2. Left Join keyword is used to apply Left Join on two tables.
Syntax for Left Join:
SELECT columnname(s)
FROM tablename1
LEFT JOIN tablename2
ON tablename1.columnname=tablename2.columnname;
In the above syntax there is a column taken from both table on which left join is applied and this column must be same in both tables.
0 Comment(s)