Learn a technique to fetch column data for MySQL crosstabs by emulating views. By replacing tables with a subquery subset, the resulting view will contain a limited dataset that has been filtered for that column field.

This story continues at http://www.databasejournal.com/featu...olumn-Data.htm