Exclude records based on table

[bernie10]

Hello everyone,
Could somebody remind me how to do the following:

Suppose I have two tables, mytable1 and mytable2, respectively.

My master data:

ID Name
1 Joan
2 Jill
3 Jenny
4 Jack

And a table of entrees I wanted excluded from my query:

ID
2
4


So I want my query results to be:

ID Name
1 Joan
3 Jenny

What would the SQL look like to do this? Thanks for the help.

Collen

 

[r937]

select master.ID
     , master.name
  from master
left outer
  join entrees
    on entrees.ID = master.ID
 where entrees.ID is null

r937.com | rudy.ca

 

[lespaul]

another way:

select master.ID, master.name  
from master
WHERE ID Not IN (Select ID From entrees)

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins