RE: [mysql] crosstabs

2007-07-31 Thread Weston, Craig \(OFT\)
31, 2007 3:56 PM To: Weston, Craig (OFT) Cc: mysql@lists.mysql.com Subject: Re: [mysql] crosstabs Hi, Weston, Craig (OFT) wrote: > In Access, designing a "crosstab" query is fairly straight forward. You > just choose "crosstab" in the query design form. Is there some

Re: [mysql] crosstabs

2007-07-31 Thread Geoff Nicol
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 c

Re: [mysql] crosstabs

2007-07-31 Thread Baron Schwartz
Hi, Weston, Craig (OFT) 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? The simplest way -- if you're used to Access -- is probably to use Acce

[mysql] crosstabs

2007-07-31 Thread Weston, Craig \(OFT\)
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 atta