Exclusive Values

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

Guest

Hello all

I have two tables. Both have a field called NSerie. There is no relation
between them.
I need to retrieve NSerie which are common to both tables. I can do that, no
problem.
I also need to retrieve NSerie which are not common to both table. This is,
I need those NSerie from table A which are not present on table B.

Any suggestions are most welcome.
 
Hello Raul.

Raul said:
I have two tables. Both have a field called NSerie.
There is no relation between them.
I need to retrieve NSerie which are common to both tables.
I can do that, no problem.
I also need to retrieve NSerie which are not common to both table.
This is,
I need those NSerie from table A which are not present on table B.
Any suggestions are most welcome.
Click to expand...

Try this:
SELECT NSerie AS [Not present in B]
FROM TableA RIGHT JOIN TableB
ON TableA.NSerie = TableB.NSerie
WHERE TableB.NSerie IS NULL

There is a wizard for searching for inconsistencies that can help you create
this query.
 
Back
Top