(Rob Gravelle) Unlike MS Access, which has the TRANSFORM…PIVOT statement, most relational databases – MySQL included – do not offer a mechanism for easily generating crosstab queries.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help