RE: SQL statement
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'george.rusnak@xxxxxxxx'" <george.rusnak@xxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 14:23:22 -0400
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@xxxxxxxx]
Sent: Tuesday, October 26, 2004 2:11 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
