title: How to include Null value in Join?
body: <p>I have a table where in the column 'AssignedRecruiter' has numerical values (Id). And it can have null values as well. </p>
  
  <p>The Id stored in this column are also present in Employee table which consists of names of Employees. On executing Join between two tables based on Table1.AssignedRecruiter = Employee.Id , I get all the values from Employee table matching with the Id of 'AssignedRecruiter'. </p>
  
  <p>However I wish to have all the null values as well. I tried Left join for picking all value from Table1 but it doesnt work.</p>