Outer Joins

  • Thread starter Thread starter Chuck
  • Start date Start date
C

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
 
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?
Click to expand...

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.
 
Back
Top