Query with several tabels

R

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 a 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Consolidation Table from Different Excel Tabs with Different Format 1
QBF & Query Malfunction 0
Some mail merge fields not pulling into document 2
How to have two tables on same line? 1
Creating a Chart on form from selected data in query. 0

Top