Theo Kramer <theo@flame.co.za> writes:
> The query is
> select accountdetail.domain from accountdetail where
> accountdetail.domain not in
> (select accountmaster.domain from accountmaster);
Try something like
select accountdetail.domain from accountdetail where not exists (select accountmaster.domain from accountmaster
where accountmaster.domain = accountdetail.domain);
I believe this is in the FAQ...
regards, tom lane