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

Combines source-table records when used in any FROM clause. Syntax FROM table1 [ LEFT | RIGHT ] JOIN table2 ON table1.field1 compopr table2.field2 The LEFT JOIN and RIGHT JOIN operations have these parts:

msdn.microsoft.com