Re: get everything from table A that is not in table B



select A.curveId
from A left outer join B
ON(A.id=B.id
where (B.id is NULL)

.