Is there any way to do the following without using subqueries or repeating the formulas?
select city, count(id) as TotalNum, sum(Weight) as TotalWeight, TotalNum/TotalWeight as AvgWeight... ________________________________________________ Get your own "800" number Voicemail, fax, email, and a lot more http://www.ureach.com/reg/tag