RE: SQL statement

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 26 Oct 2004 14:19:12 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9B5A@AABO-EXCHANGE02.bos.il.pqe>

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 ???

>=20

> pweb:acedmgr> select QID from login;


>=20

>        QID
> ----------
>          1
>          1

>=20
>=20
>=20

> pweb:acedmgr> select qid from question;


>=20

>        QID
> ----------
>          2
>          3
>          1

>=20

> pweb:acedmgr> SELECT qid=20
>                         FROM    question
>   2                    WHERE  qid NOT IN (SELECT qid FROM login);

>=20

> no rows selected

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 26 2004 - 13:14:48 CDT