HELP !!! SQL GURUS !!!! How do I do this ???
Date: 1997/04/01
Message-ID: <33413a5a.611467603_at_news.aud.alcatel.com>#1/1
[Quoted] Hey Pro's
[Quoted] Got a problem.
[Quoted] [Quoted] I'm trying to slelect a column which has numbers in it lets say 1
[Quoted] through 5, and compare it to a list of known values.
Lets say 1 through10.
I would like it to come back with all the matching numbers that are
not in the column such as 6,7,8,9,10.
[Quoted] I was trying somthing like this:
select column
from table
[Quoted] where column is not in
(select column from
table
where column is in ('1','2','3','4','5','6','7','8','9',10')
then it returns 1,2,3,4,5
what I need it to return is 6.7,8,9,10
(the exact opposite)
It seems so simple, what am I doing wrong ?? Thanks for reading it !
Jens
jens_at_deutschware.com Received on Tue Apr 01 1997 - 00:00:00 CEST