SUM function

hi-
i have a query that i need help on. basically i need to choose all the customer keys that have the sum of the sales amt * qty > 100000. i get an error message saying that i canno?t have the sum in the group function. is the below the correct syntax?

select a.KEY
from table.A
where sum(SALES_AMT*QtY)>100000
group by a.key

thanks! Received on Thu May 19 2005 - 22:21:59 CDT