已经用THISFORM.TEXT1.VALUE控制sycode产生分组效果,group by ……就多余了:
SELECT sycode,SUM(value),outdate FROM fhzl WHERE EMPTY(OUTDATE) AND ALLTRIM(SYCODE)==ALLTRIM(THISFORM.TEXT1.VALUE)
SELECT sycode,SUM(value),outdate FROM fhzl WHERE EMPTY(OUTDATE) AND ALLTRIM(SYCODE)==ALLTRIM(THISFORM.TEXT1.VALUE)
相互学习,互相交流,共同提高。