Re: SQL statement

From: <jo_holvoet_at_amis.com>
Date: Tue, 26 Oct 2004 20:22:23 +0200
Message-id: <OF7C785BC7.116DCBA2-ONC1256F39.0064E529@eu.amis.com>

Does "select qid from login" also return null values ?

mvg/regards

"Rusnak, George A. (SEC-Lee) CTR" <george.rusnak_at_deca.mil> Sent by: oracle-l-bounce_at_freelists.org
10/26/2004 20:11
Please respond to george.rusnak

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc: 
        Subject:        SQL statement

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



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

Received on Tue Oct 26 2004 - 13:18:04 CDT