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_Cov ered 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]

Re: Multiple Tables?

Ryan Ashline wrote:[color=blue]
>
> 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_Cov ered 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.
>[/color]
I hope so. What I'd do is create a FindUnmatched query for
NO_Norton_Ever and Servers_Not_Cov ered 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.MachineNa me
UNION ALL
Select MachineName,"Se rvers_Not_Cover ed" As TableName From
Servers_Not_Cov ered...