>I agree totally. I tried to run a report I produce monthly and it died. The added complexity for not going ansi may just be worth the "cheat" as I saw someone post earlier today. Especially painfull when working with denormalized data.
I also tried the approach as you proposed by adding all fields, it doesn't work. Then, I added a GROUP BY 1,2,3,4... It doesn't work either. As for now, I really can't find a way to make that work. But, I assume Sergey is coming up with an answer. :)