Re: Column condition two times

[Phillip Ward]

Quote

The query has a bug . I think the ON should be on OID not cid.

OK, so change it.

Nothing you're going to get in a forum post is going to be exactly what you need; it will [almost] always need some degree of adaptation, which requires some degree of understanding, which is what we're trying to provide.

Quote

When I do the query and select 2 categories I need the Oid's that have both categories not at least one.

And that's what you should get.
The having clause will only return you oid's that have both of the categories that you requested. If there's only one, it will not satisfy the having condition so that oid won't be included.

Regards, Phill W.