|count query [message #61529]
||Mon, 22 September 2008 15:51
Registered: May 2008
select p.property_name, COUNT(c.commentable_id) as count from promoter as p left join sf_comment as c on p.id=c.commentable_id group by p.id
how to write with Criteria.
[Updated on: Mon, 22 September 2008 15:52]