On May 20, 2005, at 11:46 AM, Rob Laveaux wrote:
You can't use a WHERE clause on the result of an aggregation. Use HAVING instead.
This should work:
select sum(ft) as Pts, pkey from playergame group by pkey having Pts > 15
Doh! Yes, that is it. Thanks a lot.
