Originally posted by abhaysk
select b.id from bx b where b.id not in ( select a.id from ax a )
Logically correct, but
select b.id from bx b where not exists (select * from ax a where a.id = b.id)
or simple
select id from bx
minus
select id from ax
would be faster.