RE: [mysql] crosstabs

From: Weston, Craig (OFT) <Craig.Weston(at)oft.state.ny.us>
Date: Tue Jul 31 2007 - 15:58:37 EDT

This is a good idea. Thanks.  

---

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.

-----Original Message-----

From: Baron Schwartz [mailto:baron@xaprb.com] Sent: Tuesday, July 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 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/mysql?unsub=lists@pantek.com

Received on Tue Jul 31 16:00:41 2007