LEFT JOIN, RIGHT JOIN Operations (Microsoft Access SQL)

In this example, CategoryID is the joined field, but it is not included in the query results because it is not included in the SELECT statement. To include the joined field, enter the field name in the SELECT statement — in this case, Categories.CategoryI

msdn.microsoft.com