RE: SQL statement
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <george.rusnak@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Oct 2004 14:19:12 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
