Select All Items In Tabel A That Are Not In Table B???

[CreedFeed]

ok I have two tables A and B, each with a field "id"... I want to select all ids from table A that are not in table B... how can this be done with a single query?

[r937]

select A.id
  from A 
left outer
  join B
    on A.id
     = B.id
 where B.id is null