sql sum query

[thindrakhya]

hi all

I am using this query and php is giving me the error

select productId , sum(quantity) from tblorderdetail where sum(quantity) > 10 group by productId


Can anyone know where i am wrong

[shyam]

select productId , sum(quantity) from tblorderdetail where sum(quantity) > 10 group by productId
thats gotta be in the having clause

select productId , sum(quantity) from tblorderdetail group by productId having sum(quantity) > 10