select unique and identical rows in different tables

  • Thread starter Thread starter Sander Caerteling
  • Start date Start date
S

Sander Caerteling

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