If I have a SELECT statement like:
SELECT cola, colb, sum(tableb.colc * tableb.cold) AS Total FROM TableA GROUP
BY cola ORDER BY Total
...I get an error, I think because of referring to Total in the ORDER BY
clause. Is it not possible to refer to column aliases anywhere within a
SELECT
On 22 October 2011 17:28, Pete p...@mollysrevenge.com wrote:
If I have a SELECT statement like:
SELECT cola, colb, sum(tableb.colc * tableb.cold) AS Total FROM TableA GROUP
BY cola ORDER BY Total
What is tableb?
...I get an error, I think because of referring to Total in the ORDER BY