select v.hphm, sum(v.jf) as jf,sum(v.fkje) as fkje, count(v.hphm) as wz, t.cx from car_violation as v join car_type as t on(v.hpzl = t.hpzl) group by t.hphm ;
报错:Unknown column 't1.hphm' in 'group statement'。
求解决方法
Unknown column 't.hphm' in 'group statement
本回答被提问者采纳