Re: HELP !!! SQL GURUS !!!! How do I do this ???
From: Cherie Howes <cherieh_at_mis.co.za>
Date: 1997/04/03
Message-ID: <5i09j2$47g$1_at_asgard.sprintlink.co.za>#1/1
Date: 1997/04/03
Message-ID: <5i09j2$47g$1_at_asgard.sprintlink.co.za>#1/1
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 CEST