Re: query crosstab

2001-10-31 Thread 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; > &g

query crosstab

2001-10-31 Thread Napis
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