How to write mutiple table query 1

[bakerm]

I need a query that will look at several different tables to obtain needed records.

ex. Select field from table where field < 0

I need to incorporate seven different tables into this one query. All the tables have the field needed named the same.

I then need a distinct list of these field values so no duplicates will be returned.

Any help will be greatly appreciated.

Mark

 

[TomSark]

If I understand the question, you can use a UNION statement as in:

SELECT field
FROM table1
WHERE field < 0

UNION

SELECT field
FROM table2
WHERE field < 0

... etc. etc.

UNION will remove duplicated from the result set...

Tom

 

[bakerm]

Did just what I needed.

Thanks Tom!!!!