Outer Joins

[Chuck]

I have two tables that I would like to join together.
The problem is I would like to see all records from both
tables whether they have a corresponding record in the
other table or not. In SQL Server I can use the Full
Outer Join command to do this. Is there a way to do this
in Access?

Thanks,
Chuck

 

[John Vinson]

I have two tables that I would like to join together.
The problem is I would like to see all records from both
tables whether they have a corresponding record in the
other table or not. In SQL Server I can use the Full
Outer Join command to do this. Is there a way to do this
in Access?

JET databases don't support full outer joins. What you can do is
create a Left Outer Join and a Right Outer Join query, and use a union
query to splice them together.