p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

sql_language thread: Please Help on SQL Query

Message #1 by "Lee Cullinan" <lee.cullinan@p...> on Mon, 11 Mar 2002 12:02:14
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.

Content-Type: text/plain

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

David Cameron

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

  Return to Index