Theo Kramer <theo(at)flame(dot)co(dot)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