MySQL Forums
Forum List  »  Newbie

Re: Column condition two times
Posted by: Dragu Costel
Date: June 17, 2016 08:09AM

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

Options: ReplyQuote


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.