| Author |
MYSQL question URGENT
|
Dorj Galaa
Ranch Hand
Joined: May 29, 2001
Posts: 113
|
|
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
|
Senior software engineer
|
 |
 |
I agree. Here's the link: jrebel
|
|
subject: MYSQL question URGENT
|
|
|