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 Access as the front-end and MySQL as the backend, through ODBC.
Otherwise, http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html cheers Baron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]