Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL statement

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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 26 2004 - 13:07:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US