Hello all, Apologize me if I post the wrong place. I am using Cross-tab Sql statement with Access 97, e.g. TRANSFORM Count(Item) as CountItem SELECT Customer FROM Sales .... GROUP BY Customer PIVOT SalesArea and tending to transfer Access' datatabse to MySQL. Is there a similar or easy way to create statement like this with MySQL? Thank you in advance. Krung. PS. I use DBI 1.14, DBD::ODBC 0.28, DBD::mysql 2.0400
