[SOLVED] sum fields in where clause

[AlexanderTheGr]

Hi

 

I have that query

 

Select (sum(field1*field2)) as c from table where c > 100 group by field4

 

And i got that error

 

Unknown column 'c' in 'where clause'

 

Any idea how can i have a similar query

[luca200]

Not sure it'll work, but try this way

 

Select (sum(field1*field2)) as c from table group by field4 having c > 100

 

[GingerRobot]

Yeah, you cannot refer to an alias in the WHERE clause. Not entirely sure why. luca200's solution should work for you.

[AlexanderTheGr]

Thx luca

 

Its seems its works

[luca200]

Yeah, you cannot refer to an alias in the WHERE clause. Not entirely sure why.

Because WHERE is executed BEFORE select, so it does'nt know aliases at the time. You have to repeat the expression if you have some.

Anyway, in this case it was wrong at all to put the condition in the WHERE clause, even repeating the expression, because you can't test a condition on a grouped value in WHERE.