Need proficient way to build query

L

Leslie

I have two tables. One that lists all records and another table that lists
selected records from the first table. I need to pull all the records from
the first table that are not included in the second table and that meet
certain criteria. (e.g. value = Y)

Will a join pull back the results I'm looking for?

Thanks!
 
T

Tom Ellison

Dear Leslie:

A LEFT JOIN from the first table to the second and omitting those rows where
the second table key is NULL would do this. A NOT IN() can do this also.

Tom Ellison
 
Top