Hello All,
I just started playing with the GROUP BY statement and
it looks like it does nothing more than group similar
rows toghether into one returned row. What should I do
if I want the grouped rows totaled and returned as
multiple rows? For example:

GROUP AND TOTAL BY A

A B C
------------
3 X X
3 Y Y
3 X Y
-----------
Group Total = 3

4 Y X
4 Y X
-----------
Group Total = 2

Thanks,
Derek Basch



__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com