Re: HELP !!! SQL GURUS !!!! How do I do this ???

You could also try something like this ,but only if you have your values that you want to test against in a another table:

select a.column
from table_unknown_values a,table_known_values b where a.column = b.column(+)
and b.column is null

that way it will return all the values in table alias a that do not occur in table alias b. Received on Thu Apr 03 1997 - 00:00:00 CST