This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Post your database structure. Off hand it sounds like you need to split that
into more tables.
From: Lee Cullinan [mailto:lee.cullinan@p...]
Sent: Monday, 11 March 2002 11:02 PM
To: sql language
Subject: [sql_language] Please Help on SQL Query
I have 1 table with a list of items, year, month and number of invoices. I
need to create multiple columns and group the sum of quantity results for
each product and period into new month columns in the same or different
table i.e. product 'a' for january sold 500 units 200 in feb 300 mar etc
etc any ideas please