Re: SQL query for finding values that are not contained in a table

Thanks Jens, It actually works. Nice trick :) I wished that sql treated expression lists like subqueries in order to make queries like this simpler.

E.g if we could say something like

select * from ('a1', 'a2', ....)
MINUS
select col1 from tab1

D. Received on Wed Oct 19 2005 - 15:37:28 CDT