468,241 Members | 1,718 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,241 developers. It's quick & easy.

Multiple Tables?

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
Nov 12 '05 #1
1 2136
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...
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by E Arredondo | last post: by
11 posts views Thread by dskillingstad | last post: by
1 post views Thread by Ahmet Karaca | last post: by
8 posts views Thread by Jason L James | last post: by
7 posts views Thread by =?Utf-8?B?TG9zdEluTUQ=?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.