Left Join that always includes null records
If you want to join the two tables even when there is a non match, you will need to use
IS NULL on your joined columns.
Select,CustomerID,CustomerName,ISNULL (CustomerEmail, NULL) AS CustomerEmailFROM table1LEFT JOIN table2ON table1.CustomerID = table2.CustomerID
This wil bring back results with