By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Multiple Tables?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.