$map["a.sum(jine)"] = array('between',[$data['start'],$data['end']]);
}
$res=$this
->where($map)
->alias('a')
->join('zhanghao w ','w.zyzh = a.laiyuan')
->field('ti
->order('zonghe desc')
->group('ti
->limit($from, $size)
->select();
金额是sum后的金额,但是我查询的时候,报错了,我想查询的是对sum后的金额,进行区间查询,该怎么写呢
最佳答案