List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 1 2001 5:13am
Subject:Re: query crosstab
View as plain text  
>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



Thread
query crosstabNapis1 Nov
  • Re: query crosstabPaul DuBois1 Nov