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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weird 2007 left join query 1
Left Join is excluding data from left table 8
NOT IN (SQL) or Find Unmatched (+ other stuff) 21
perform INNER JOIN on query results 2
Making a Delete Qiuery from an unmatched Query 3
Left Join Not Returning All Records 2
Inner , Right, Left JOIN 14
Query on two tables with matching null fields 4

Back
Top