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