aspose file tools*
The moose likes JDBC and the fly likes MYSQL question URGENT Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MYSQL question URGENT" Watch "MYSQL question URGENT" New topic
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: http://aspose.com/file-tools
 
subject: MYSQL question URGENT
 
Similar Threads
SQL statement question
JOIN with three tables ?
newbie hibernate question regarding joins
left outer join
Joining 3 Tables