>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 --------------------------------------------------------------------- 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
