0

I've been away from sql for quite a well and need a little push to get restarted. Need to report out of a single table, with values coming out of only two columns.

Need to group items from column 1 as the left column in the ouput table with totals for each type in column two forming the row for the grouped item. To look something like:

Category Type 1 Type 2 Type 3 Type 4

abc 5 3 1 40
def 10 8 8 5
---------------------------------------------------------------
Total 15 11 9 45


Should be easy stuff, right? I don't have the option of pulling the query into a script otherwise this would be almost painfully easy in php or perl

thanks much!!

Jim

2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by jimesten
0

Thanks for the pointer to the dev zone at mysql.com. I think I followed enough of that to make some headway!!

thanks much,

Jim

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.