OraFAQ Forum: Server Administration » "NOT IN" operator with more than one condidition

Home » RDBMS Server » Server Administration » "NOT IN" operator with more than one condidition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

"NOT IN" operator with more than one condidition [message #370897]

Fri, 03 March 2000 08:50

Halvor Nyberg
Messages: 2
Registered: March 2000

Junior Member

I did it like this:
"Select max(REVISION), ITEM_KEY From ITEM
where (ITEM_TYPE)=0 and ITEM_KEY||REVISION
NOT IN (SELECT PARENT_ITEM||PARENT_REVISION from ITEM_PS_DEF)
group by ITEM.ITEM_KEY"

But how do I do it by using AND instead of || (concat)

Regards Halvor
http://members.tripod.com/Nybbies/vb.htm
http://members.tripod.com/easydoc/dim.htm

Report message to a moderator

Re: "NOT IN" operator with more than one condidition [message #370911 is a reply to message #370897]

Mon, 06 March 2000 05:33

Thierry Van der Auwera
Messages: 44
Registered: January 2000

Member

Hallo Halvor,

You do it like this :

Select max(REVISION)
, ITEM_KEY
From ITEM
where (ITEM_TYPE) = 0
and (ITEM_KEY,REVISION) NOT IN (SELECT PARENT_ITEM,PARENT_REVISION
from ITEM_PS_DEF)
group by ITEM_KEY

Greetings,

Thierry

Report message to a moderator

Previous Topic:	Re: Any good library of SQL*Plus scripts anywhere?
Next Topic:	Which is faster Join or subquery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 28 21:13:55 CST 2023