SELECT fayou.日期,fayou.品种,fayou.表号,fayou.起码,fayou.止码,fayou.走字数zfayou.ygkg FROM zfayou JOIN fayou ON zfayou.PZ=fayou.品种 INTO CURSOR temp11 ORDER BY 品种,表号
我想问的问题是字段zfayou.ygkg 被重复显示，怎样不重复显示？

SELECT fayou.日期,fayou.品种,fayou.表号,fayou.起码,fayou.止码,fayou.走字数,zfayou.ygkg FROM zfayou JOIN fayou ON zfayou.PZ=fayou.品种 INTO CURSOR temp11 ORDER BY 品种,表号

查询的目的是想把2个表合并，然后作为报表的数据源，zfayou.ygkg重复，导致报表汇总的数据也是错的，报表需要对zfayou.ygkg，和”fayou.走字数“等字段放在一起统计。

tlliqi师傅，不能以zfayou.ygkg分组，报表必须以品种分组

SELECT fayou.日期,fayou.品种,fayou.表号,fayou.起码,fayou.止码,fayou.走字数,fayou.erps,fayou.差异,fayou.lljkg,fayou.erpkg,zfayou.ygkg ,zfayou.youguan,;
zfayou.back1,zfayou.back2,zfayou.cy2 FROM zfayou JOIN fayou ON zfayou.PZ=fayou.品种 INTO CURSOR temp11 ORDER BY 品种,表号

以上是数据源，一下是报表

在报表里的总结带区，关于zfayou.ygkg 和zfayou.cy2 因为重复值，总结的结果是错误的