SQL LEFT JOIN

The LEFT JOIN or LEFT OUTER JOIN is used to retrieve all the records from the Left table (Table A) if there is no match with the Right table (Table B). If there is no match in the right table then the result will have NULL representing the column for the right table. If any value matches with the left table so that particular record will be present in the result.

• Syntax of LEFT JOIN –

SELECT column1,column2,column3,...,columnN FROM TableA
LEFT JOIN
TableB
ON TableA.column_name = TableB.column_name ;


Example – Consider these two tables the Product table and the Manager table.

Demo Table – 

Product Table

Manager Table

Now the below query will return all the records from the Product table even if there is no match in the Manager’s table.

SELECT
A.Category,A.City,A.[Customer Name],B.Region,B.[Regional Manager]
FROM [dbo].[Products] AS A
LEFT JOIN
[dbo].[Manager] AS B
ON A.Region = B.Region;


This output is the small section of the output by executing the above query –