>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