SQL statement

From: Rusnak, George A. (SEC-Lee) CTR <george.rusnak_at_deca.mil>
Date: Tue, 26 Oct 2004 14:11:09 -0400
Message-ID: <C6687CF5DD6CA449BD4149E7D1485E3FA8A06F@A10HQCIS0MAIL01.apps.deca.mil>

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_at_deca.mil

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 26 2004 - 13:07:29 CDT