Re: query crosstab

[Paul DuBois]

>Help me ...
>
>this query ( query crosstab) in microsoft access .. ( success)
>
>TRANSFORM Sum(neraca.bsu) AS SumOfbsu
>SELECT neraca.ket_rek AS Keterangan
>FROM neraca
>GROUP BY neraca.no_rek, neraca.ket_rek
>ORDER BY neraca.no_rek
>PIVOT neraca.bln_thn;
>
>when me running in MYSQL ... ERROR ... why ??

Because TRANSFORM isn't legal in MYSQL.  However, you might find this
article of some value:

http://www.mysql.com/articles/wizard/index.html

It deals with crosstabs.

>
>thank's
>
>napis