Does anyone have any ideas why this is not working ??? pweb:acedmgr> select QID from login; QID ---------- 1 1 pweb:acedmgr> select qid from question; QID ---------- 2 3 1 pweb:acedmgr> SELECT qid FROM question 2 WHERE qid NOT IN (SELECT qid FROM login); no rows selected ============================================================ pweb:acedmgr> desc login Name Null? Type ----------------------------------------- -------- --------------- USER_ID NOT NULL VARCHAR2(20) PSWD NOT NULL VARCHAR2(32) PSWD_CHG_DTE DATE LAST_NAME NOT NULL VARCHAR2(30) FIRST_NAME NOT NULL VARCHAR2(30) LOCKED VARCHAR2(1) CREATED_BY NOT NULL VARCHAR2(20) CREATED_DTE NOT NULL DATE QID NUMBER(6) ANSWER VARCHAR2(100) USER_ROLE VARCHAR2(1) pweb:acedmgr> desc question Name Null? Type ----------------------------------------- -------- -------------- QID NOT NULL NUMBER(6) QUESTION NOT NULL VARCHAR2(200) ================================================================= TIA Al Rusnak DBA - CISIS, Computer Operations * 804-734-8210 * george.rusnak@xxxxxxxx -- //www.freelists.org/webpage/oracle-l