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
 
We would need to see the table structures before we could help you.
 
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

select identical and unique rows in different tables 1
Union and group, then count 1
List unique records and combine from two tables 1
How to Populate Data from a table to another 0
Turning a 3 column flat file into a "3D" Table 2
Word VBA for deleting Selected Row 0
SELECT @@IDENTITY in A2010 with Triggers 6
Access Sorting and grouping using multiple tables 0

Back
Top