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:

It deals with crosstabs.


query crosstabNapis1 Nov
  • Re: query crosstabPaul DuBois1 Nov