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
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 Sc.ID=I.
