> mySQL has a slew of both aggregate and mathamatical functions: > http://www.mysql.com/doc/en/GROUP-BY-Functions.html > http://www.mysql.com/doc/en/Mathematical_functions.html > Which are all useful for reporting.
Yep, I'm familiar with these, and the aggregation needed cannot be done at the level of single column queries like this, or even by clever inclusion under WHERE conditions and the like. There are all sorts of weird conditions associated with the aggregation. I'm using SUM and AVG for some of them, but they are mostly figures which need to be aggregated then transformed (e.g. by operations on the data of two or more columns or excluding some records) then sorted. Hence the original need for Temp tables. > Which version of mySQL are you using? These days it matters with the new stuff in > 4.0. Help About says only "MySQL Control Center 0.9.3-beta" > ------------------------------------------------------------------ > [EMAIL PROTECTED] > ICQ: 3094740 > Safe From Bees --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
