Multiple Tables?

[Ryan Ashline]

OK here's what I have so far...

I have a query named TEST1 that runs on a table named 10251_IP_Range.
I get a list of "Machine" names that all have certain data in a
field. What I need to do now is take the data (The "Machine" Names)
that the query gives me and run it against two other tables. The two
tables are NO_Norton_Ever and Servers_Not_Covered each of these two
tables have a fieled called "Name". I need it to exclude any name
from the TEST1 query if the "Machine" field matches with either "name"
field from the other tables. I hope my question sounds clear enough.

Thanks for your help

Ryan Ashline

[Patrick Finucane]

Ryan Ashline wrote:

OK here's what I have so far...

I have a query named TEST1 that runs on a table named 10251_IP_Range.
I get a list of "Machine" names that all have certain data in a
field. What I need to do now is take the data (The "Machine" Names)
that the query gives me and run it against two other tables. The two
tables are NO_Norton_Ever and Servers_Not_Covered each of these two
tables have a fieled called "Name". I need it to exclude any name
from the TEST1 query if the "Machine" field matches with either "name"
field from the other tables. I hope my question sounds clear enough.

I hope so. What I'd do is create a FindUnmatched query for
NO_Norton_Ever and Servers_Not_Covered to Test. If you make each query
have the same columns I'd then make these 2 queries a union query.

Select MachineName,"NO_Norton_Ever" As TableName
From NO_Norton_Ever Left Join Test1 On
NO_Norton_Ever.MachineName = Test1.MachineName
UNION ALL
Select MachineName,"Servers_Not_Covered" As TableName From
Servers_Not_Covered...