Re: Pulling my hair out with this query

[Reo Lucas]

Thanks Aziz!

Someone showed me another technique using CASE:

"SELECT NAME
, sum(case when `YEAR` = 2002
then TEST1 end) as total2002
, sum(case when `YEAR` = 2003
then TEST1 end) as total2003
, sum(case when `YEAR` = 2004
then TEST1 end) as total2004
FROM mydata
group
by NAME";

I'm trying now to figure out which of the two methods is the more efficient method (given about 1 million records).