Returning records NOT in a table

  • Thread starter Thread starter Rodtnick
  • Start date Start date
R

Rodtnick

I have a programing data base that is has two tables (Programs and Used)
linked at ProgramID. When I schedule a program for air the date of that
program is added into the Used table. I want to choose all the programs
that have not been used, in other words do not have an entry into the
Used table. How can I do that?

Bruce Rodtnick
 
There is an Unmatched Query Wizard to do this for you.

In essence, it is an outer join where Used.ProgramID is null.
 
Back
Top