Re: Column condition two times

[Phillip Ward]

Quote

SELECT * FROM `node_index` n LEFT JOIN `category` c on n.oid = c.oid WHERE c.cid = 1 AND c.cid = 2 GROUP by n.oid;
The SQL is wrong but is want I want.

The HAVING clause is what you're looking for:

select    n.oid 
from      node_index n 
left join category c 
     on   n.cid = c.cid 
where     c.cid in ( 1, 2 ) 
group by  n.oid
having    count( c.cid ) = 2 
order by  n.oid ;

Regards, Phill W.