Myles : Thanks for this info. Clears up that mystery for me.
However, when I try:
So why not: select *, (StkhistMonthqty06 + StkhistMonthqty07 +
StkhistMonthqty08) as total
.
. rest of statement ...
.
and total > 0
I get a
[nativecode=1054 ** Unknown column 'total' in 'where clause']
I had actuall
Ross,
That's correct. From the MyQL manual:
Begin quote ..
In a SELECT statement, each expression is evaluated only when sent to the
client. This means that in a HAVING, GROUP BY, or ORDER BY clause, you
cannot refer to an expression that involves variables that are set in the
SELECT list. F