Does anyone know of how to write something to the effect of:
Code:
SELECT myRealField + 1 AS 'f1', f1 / 2 AS 'f2'
I know it could be be accomplished with
HTML Code:
SELECT myRealField + 1 AS 'f1', (myRealField + 1) / 2 AS 'f2'
but I would rather not have to duplicate (myRealField + 1) in multiple places in the query.