[thelist] IMPORTANT UPDATE MySQL to Excel Problem Pivot Table SOLVED! [long]

rudy r937 at interlog.com
Thu May 2 14:08:01 CDT 2002

> SUM(IF(RecordID = 'Foo', Weight, 0)) AS FooWeight
> Ah the power of SQL. rudy, you may obviously keep your sceptre,
> I am in no position to be a prince, much less a king.

don't sell yourself short

you figured this one out on your own, and crosstab sums are pretty tricky

just a comment --

not every database has an IF or CASE structure

you can achieve similar results by grouping from a temp table which holds
crosstab results generated from the union of several selects -- see


More information about the thelist mailing list