Re: Column condition two times
Hi Phill,
The query has a bug . I think the ON should be on OID not cid.
However is not what I want.
Oid 1 , has category 1 and 2
Oid 2 , has category 2
When I do the query and select 2 categories I need the Oid's that have both categories not at least one.
I try you query and the result is Oid 1 and Oid 2
Subject
Written By
Posted
Re: Column condition two times
June 17, 2016 08:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.