Select identical and unique rows in different tables

[SanderC]

Hi there!

I have a database system of three table consisting of partly identical information.
Now I want a few things:
-I want to select the rows from the tables that are present in all three tables.
-I want to select the rows from the tables that are present in two tables and not in the other one.
-I want to select rows that are unique to table 1

Can you help me with the SQL statements that make these selections, because I don't seem to get it working....
And also, is it possible (in Microsoft Access) to combine these SQL statements in one big querie?

Many Thanks!
Sander

 

[PHV]

Have a look at the difference between INNER and OUTER joins.
combine these SQL statements in one big querie
Have a look at the UNION operator.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886