Calculating fields in a view

[mikeEd]

I have a view that is something like the following:

SELECT
	(Field1 * 10) AS CalcField1,
	(Field1 * 10) + Field2 AS CalcField2,
	(Field1 * 10) + Field2 - 2 AS CalcField3
FROM
	TABLE

i.e. Subsequent fields are calculated based on the value of earlier calculated fields.
Is there any obvious way to do...

SELECT
	(Field1 * 10) AS CalcField1,
	CalcField1 + Field2 AS CalcField2,
	CalcField2 - 2 AS CalcField3
FROM
	TABLE

Thanks.

 

[crystalized]

The way you have it written in the first version is the only way I know of to do something like that. I know I have often wished when I had a significant calculation to do and then needed the result for another one I wished I coud just use the field name but alas...... Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde