RE: SQL statement

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Tue, 26 Oct 2004 14:23:22 -0400
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE07A7F9D6@exchsen0a1ma>

George,

Works fine for me in 9.2. What version you working on?

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Rusnak, George A. (SEC-Lee) CTR [mailto:george.rusnak_at_deca.mil] Sent: Tuesday, October 26, 2004 2:11 PM
To: 'oracle-l_at_freelists.org'
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:19:27 CDT