>
> isnt there just a way to use those calculated values, referenced in the
> beginning of the query, later on down in the query?
SELECT
*
FROM (
SELECT
count(tony) as tonysCount,
sum(jayme) as jaymesCount
FROM
orders
) a
WHERE
Abs(tonysCount-jaymesCount)/tonysCount) > 0
Whether this is faster depends on the circumstances.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
