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

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

RE: SQL statement

From: Rusnak, George A. (SEC-Lee) CTR <george.rusnak_at_deca.mil>
Date: Tue, 26 Oct 2004 14:27:11 -0400
Message-ID: <C6687CF5DD6CA449BD4149E7D1485E3FA8A070@A10HQCIS0MAIL01.apps.deca.mil>

THANK YOU !!
THANK YOU !!! It was a NULL !!!!!

Much appreciated !!!!

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com] Sent: Tuesday, October 26, 2004 2:19 PM
To: Rusnak, George A. (SEC-Lee) CTR; oracle-l_at_freelists.org 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

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

Original text of this message

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