Using ROLLUP in my GROUP BY, I have been able to get MySQL to insert
sub-total lines, which is great. However, it would be even better if I
could determine the text on those subtotal lines. Here's my query:
SELECT Sc.State, St.Description, Count(*)
FROM InvHead I
JOIN Schools Sc on
In the last episode (May 02), Jesse said:
Using ROLLUP in my GROUP BY, I have been able to get MySQL to insert
sub-total lines, which is great. However, it would be even better if I
could determine the text on those subtotal lines. Here's my query:
SELECT Sc.State, St.Description,
