RE: SQL statement

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