Right and Left Join at the same time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

I have two tables A & B,
I would like to join them, so that I get the Inner Join, plus all the
unmatched records from table A plus all the unmatched records from table B.
Can this be done in Access 2000? If so, can you give me sample SQL systax.
 
mscone2000 said:
HI,

I have two tables A & B,
I would like to join them, so that I get the Inner Join, plus all the
unmatched records from table A plus all the unmatched records from
table B. Can this be done in Access 2000? If so, can you give me
sample SQL systax.
Click to expand...

You need three queries. One with an outer join that gets all of table A,
another that gets all from table B and then a UNION query that combines the
two. A FULL OUTER JOIN would do what you want in a single query, but Access
doesn't support that.
 
Thanks Rick,

I suspected that 3 queries was my only option, but I just
wanted to confirm before I spent too much time on it.
 
Back
Top