Is it possible to create a Crosstab or Pivot Query
(where the values of a certain field become the column headers) in MySQL
ex.
+--------------+------------+------------+------------+
| Name | 1984 | 1985 | 1986 |
+--------------+------------+------------+------------+
| John | 700$ | 850$ | 600$ |
+--------------+-----------+-------------+------------+
| Bill | 800$ | 630$ | 100$ |
+--------------+-----------+-------------+------------+
| John | 40$ | 450$ | 620$ |
+--------------+-----------+-------------+------------+
if so does anybody know the Syntax I have looked for it in the docs but to
no avail.
Roger Karnouk
---------------------------------------------------------------------
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
