SELECT yd_yonghda.huh,
max(yd_yonghda.yuanhh),
min(yd_yonghda.quh),
....
sum(yd_yonghbz.bianyqbh),
'' bianyqmc FROM yd_yonghda,yd_yonghbz
where yd_yonghda.huh=yd_yonghbz.huh
group by yd_yonghda.huh
ORDER BY yd_yonghda.dangah ASC or :
group by yd_yonghda.huh,
yd_yonghda.yuanhh,
yd_yonghda.quh,
yd_yonghda.suoh,
yd_yonghda.zhanh,
yd_yonghda.hum,
yd_yonghda.yongddz,
yd_yonghda.yonghzt,
yd_yonghda.chaobh,
yd_yonghda.dangah
max(yd_yonghda.yuanhh),
min(yd_yonghda.quh),
....
sum(yd_yonghbz.bianyqbh),
'' bianyqmc FROM yd_yonghda,yd_yonghbz
where yd_yonghda.huh=yd_yonghbz.huh
group by yd_yonghda.huh
ORDER BY yd_yonghda.dangah ASC or :
group by yd_yonghda.huh,
yd_yonghda.yuanhh,
yd_yonghda.quh,
yd_yonghda.suoh,
yd_yonghda.zhanh,
yd_yonghda.hum,
yd_yonghda.yongddz,
yd_yonghda.yonghzt,
yd_yonghda.chaobh,
yd_yonghda.dangah
sum , max , min , avg
sum , max , min , avg'
出现在group by里面 否则就会错误
也就是一楼说的
所有没有使用聚集函数的列都必须是group by 的分组列!!!