LEFT JOIN, RIGHT JOIN Operations (Microsoft Access SQL) [Access 2007 Developer Reference]

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

msdn.microsoft.com