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!!