Select Records from One Table that Aren't in Another Table

G

Guest

I have two tables: one is a ParksUIC table containing a list of drywells.
The other is a Lookup table containing all known potable discharge wells.

what i want to do is create a query that will only select records from the
ParksUIC table that ARE NOT in the Lookup table. This is easy to do for when
I am trying to select records that ARE in both tables (just create a
relational link between common fields) but what about when you want to invert
the selection? Can this be done in one query?

Any suggestions are welcome. Thank you, Ruben.
 
G

Guest

perfect; the wizard shows that a Left Join is required, which I had not
realized earlier (though I did set the other parts of the query up properly).

THANKS!
 

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

How to Populate Data from a table to another 0
Create Conditional Make-Table Query 4
Find records in one table without relations in another 3
SQL: Finding Data That Is In One Table But Not The Other 4
editing a set of records selected from value in a second table 3
Parsing a table 1
Table lookups with queries 8
Copy records from one table to another 2

Top