RE: SQL statement
- From: "Rusnak, George A. (SEC-Lee) CTR" <george.rusnak@xxxxxxxx>
- To: "'Bobak, Mark'" <Mark.Bobak@xxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 26 Oct 2004 14:27:11 -0400
THANK YOU !!
THANK YOU !!!
It was a NULL !!!!!
Much appreciated !!!!
-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx]
Sent: Tuesday, October 26, 2004 2:19 PM
To: Rusnak, George A. (SEC-Lee) CTR; oracle-l@xxxxxxxxxxxxx
Subject: RE: SQL statement
Most likely answer:
QID in the login table has at least one row where it's NULL.
Don't forget that NULL is UNKNOWN.....
-Mark
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
