Left join returns all the records from the left-hand side of the table which is specified in the ON condition, only those records from the right table where the join condition is met.

BY Best Interview Question ON 19 Feb 2019

Example

syntax:-

SELECT columns

FROM table1

LEFT JOIN table2

ON table1.column = table2.column;