Use a LEFT JOIN operation to create a left outer join. Left outer joins include all of the records from ...
msdn.microsoft.com