Re: [mysql] crosstabs

A good article on crosstab queries in MySQL is located at: http://dev.mysql.com/tech-resources/articles/wizard/print_version.html

A method of making a stored procedure based on the above article is hosted at:
http://www.futhark.ch/mysql/106.html

If you replace the 'sum' function with 'max' you can also create a crosstab of text values instead of simply totals.

On 7/31/07, Weston, Craig (OFT) <Craig.Weston@oft.state.ny.us> wrote:
>
> In Access, designing a "crosstab" query is fairly straight forward. You
> just choose "crosstab" in the query design form. Is there some simple
> way to replicate this functionality within mysql?
>
>
>
> Thanks,
>
> Craig
> --------------------------------------------------------
> This e-mail, including any attachments, may be confidential, privileged or
> otherwise legally protected. It is intended only for the addressee. If you
> received this e-mail in error or from someone who was not authorized to send
> it to you, do not disseminate, copy or otherwise use this e-mail or its
> attachments. Please notify the sender immediately by reply e-mail and
> delete the e-mail from your system.
>
Received on Tue Jul 31 15:59:43 2007