SQL Query Question
From: Charcoal <who_at_cares.com>
Date: Fri, 11 May 2001 11:24:09 GMT
Message-ID: <tZPK6.141$V5.300_at_news1.rivrw1.nsw.optushome.com.au>
Date: Fri, 11 May 2001 11:24:09 GMT
Message-ID: <tZPK6.141$V5.300_at_news1.rivrw1.nsw.optushome.com.au>
Hi people,
For example, in my MyTable there is the following data: 1, 4, 7, 32, 54 (there are 5 records in my table).
Now how would I write a query to show all the numbers < 100 that are not in this table? ie, it should show 2, 3, 5, 8, .... etc.
Any ideas welcome?
Charlie Received on Fri May 11 2001 - 13:24:09 CEST