This week's book giveaway is in the Java in General forum. We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield 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