[fpc-pascal] sqldb query error on group by with where clause

[Stephano]

select k_province, k_city, k_school, count(file_id), >sum(amt_student) from upload_log where (date(upload_time)>='2007-09-14') group by k_province, k_city having k_province='205' >and k_city='205031';

raises exception...Add k_school to the group by clause.Stephano

_______________________________________________
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal