Re: [SQL] columnar format

2003-07-08 Thread Christoph Haller
> > i would like to ask for the sql statement to the output: > > ITEM DESC Jan Feb Mar Apr ... Sep Total > xx 999 999 999 999 ... 999 9,999 > > where "Jan" column is sum of all "x" items purchased on Jan, "Feb" column as > sum of Feb purchases, and so on up to "Sep", and "

[SQL] columnar format

2003-07-01 Thread Don Soledad
good day! i would like to ask for the sql statement to the output: ITEM DESC Jan Feb Mar Apr ... Sep Total xx 999 999 999 999 ... 999 9,999 where "Jan" column is sum of all "x" items purchased on Jan, "Feb" column as sum of Feb purchases, and so on up to "Sep", and "Tot