outer join syntax

[Guest]

Does Access support outer join?
Any alternatives?

THANK YOU

 

[Brian Camire]

Yes.

Syntax is of the form:

FROM table1 [ LEFT | RIGHT ] JOIN table2
ON table1.field1 <operator> table2.field2

LEFT or RIGHT identifies the table (by its position in the join expression)
for which all records will be returned, even if there are no matching
records in the other table.

For example (from the help), the following query joins the Categories and
Products tables on the CategoryID field. The query produces a list of all
categories, including those that contain no products:

SELECT
CategoryName,
ProductName
FROM
Categories
LEFT JOIN
Products
ON
Categories.CategoryID = Products.CategoryID;