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.

------_=_NextPart_001_01C1CA0F.EF2CDEE0
Content-Type: text/plain

Post your database structure. Off hand it sounds like you need to split that
into more tables.

regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
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 
$subst('Email.Unsub').