Need proficient way to build query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top