On 15 Nov 2006 10:18:56 -0800, com wrote:
The key word you're looking for is "pivot". I'll skip the rest of the
answer as I've never done them under MySQL.
Life does not cease to be funny when people die any more than it ceases
to be serious when people laugh.
-- George Bernard Shaw