Re: SQL Query Question

You have to have another table (ex. Table1) with at least 99 records. Then make a temporary table Table2(CREATE TABLE TABLE2 (allnumber NUMBER) and populate it with this command: INSERT INTO Table2 (SELECT rownum FROM Table1 WHERE rownum <100).
Finally, issue this command:
SELECT allnumber FROM Table2 WHERE allnumber NOT IN (SELECT * FROM MyTable).

Hope that thi will work.
Mladen. Received on Fri May 11 2001 - 07:46:27 CDT