SQL Query Question

Hi people,

Assume I have a table which is just a list of numbers (only 1 column). I want to perform a query which shows every number under 100 which is NOT in the table. How do I do this?

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 - 06:24:09 CDT