LEFT JOIN IN SQL SERVER
Left Join:- It returns all records from the left table and matching records from the right table.
Syntax:-
Select a.Coloumn1,a.Coloumn2,b.Coloumn1,b.Coloumn2
from Table1 as a LEFT JOIN Table2 as b
Where a.CommonField= b.CommonField
Example:-
Select a.Name,a.Department,b.CompanyName,b.Degination
from Employee as a LEFT JOIN Company as b
Where a.EmplyeeId= b.CompanyID