This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
I have a SELECT statement that looks like the following: SELECT * FROM products LEFT OUTER JOIN grouping ON (products.itemNum = grouping.itemNum) LEFT OUTER JOIN english ON (products.itemNum = english.itemNum) WHERE products.category = pictures AND products.subCategory = framed GROUP BY grouping.groupingWith ORDER BY products.displaySequence; Can ayone tell me how I can incorporate a aggregate function into this select so as to be able to get the rowcount of just the GROUP BY ? Thanx