Results 1 to 5 of 5
Mar 14, 2013, 10:33 #1
- Join Date
- Dec 2008
- 2 Post(s)
- 0 Thread(s)
GROUP BY and then COUNT without a subquery?
Is it possible to group by and then get a total count of all the rows without a subquery? I think the answer is no, but thought it was worth asking.
This is my query at the moment, which does what I want, but has a subquery:
SELECT COUNT(*) AS count FROM ( SELECT 1 FROM img_categories LEFT JOIN categories AS node ON node.id = img_categories.categories_id, categories AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND parent.id = 16 GROUP BY img_categories.img_id ) AS tbl