You can use a left outer join which works in all databases.
from tablea a
left outer join tableb b on (b.value = a.value)
where b.value is null;
Databases are generally pretty good at doing joins so this usually performs good.
From: איל (Eyal) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 03, 2010 1:14 PM
To: [EMAIL PROTECTED]
Subject: NOT IN query
I have a table A with some values and another table B with some other values
How do I get all the distinct values from A that are NOT in B
if table A has values 1,2,3,4,1,2,3,5,6,7 and B has values 2,3,4,5,6
then the result should be 1,7