I didn't have time to try out your hints/techniques described in your earlier post, but after playing around a bit with the web frontend I decided that it would be more user intuitive to used the month as column and the state as row... The reason being my change of heart is I also have a similar report to build for cities, so I prefer using the variable data (ie. state/city) as rows and keep the fixed data (ie. month) as column.
Stephane -----Original Message----- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:01 AM To: Danis Stéphane (NHQ-AC); [EMAIL PROTECTED] Subject: Re: SQL Query Help Stéphane, Have just re-read my response... ***** The main problem is the layout and the order of the results set. I will have 9 state (provinces) and I would prefer the month to be the columns. The ideal results would look like this, Please note I have only included 5 state and there is 9 but you see what I'm looking for, also the statement_date is always the 1st of the month: ***** After asking you if the months and states/rows and columns could be transposed, was I dozy enough to suggest an answer that is the wrong way around??? Whilst I would recommend that the answer table be constructed to have fewer columns than rows, maybe you have your reasons... If you do want to transpose the answer given, can you manage it from the hints/techniques described, or do you need me to take another run at it? Regards, =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php