unique list of records from 3 different tables

[Olga]

have 3 tables with some cross-references, need to create query with unique list of records listed in one specific field of any of these 3 tables.
Thank you!

[orange]

I don't understand.PLease explain with some sample data.

[Olga]

More specific: 3 tables (sets) of projections that have the same well listed multiple times in the table and/or across all 3 tables.
I need a unique list of records extracted from 3 tables.

All I can think about at this time is append them all in one table and run query with unique values only.
I'm not familiar with crosstab query, may need to explore that one.

Thanks,
Olga

[orange]

I suggest you do some research on UNION query, and see if that applies to your situation.
see
http://www.techonthenet.com/sql/union.php

[Olga]

I don't know much about union query, looks like it's time to learn!
Thank you!