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

Stephano patspiper at yahoo.com
Sat Sep 15 15:39:58 CEST 2007


>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




More information about the fpc-pascal mailing list