I would like to refer to calculated columns in other columns. I thought a column alias would do it, but apparently they're only for aggregation, like GROUP BY.
Other than repeating the entire calculation, what techniques are available for accessing such a calculation? I'm calculating an electric bill, based on meter readings. I need to subtract two meter readings, and use that number in several other calculations, for example. ---------------- :::: Transformation is not what happens once we've "changed"; it's coming out of the dark and seeing what we've got and relating to it appropriately and clearly. If we've got a funnel in our hands but we think it's a bucket, we're going to keep losing things we value. If we know we've got a funnel, then we stick one finger in the hole and use it like a bucket to get by in the absence of one. We're "transformed" when we fully know who we are — or, even more important, who we are not. -- Rick Lewis :::: Jan Steinman, EcoReality Co-op :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
