现在我的sql是这样selects.MACHINECODE SMT设备编码,s.MACHINENAME SMT设备名称,s.MACHINETYPE SMT设备类型,s.MACHINESITECODE SMT设备站点编码,s.MACHINESITENAME SMT设备站点名称,s.FGCODEVERSION 物料型号编码,s.DESCRIPTION 物料型号名称,s.FGCODE 物料型号规格,s.FGKIND 物料定制规格,s.WORKORDER 工单编码,s.BACKUP4 方案名称,s.EVENTTIME 方案提取时间,s.EVENTUSER 方案提取人,i.MATERIALID 包装编码,i.EVENTUSER 上料人,i.EVENTTIME 上料时间,i.EVENTNAME 操作事件,i.FIXTURENAME 飞达名称,i.BOXQTY 包装数量,i.LASTQTY 包装现有数量,u.USERNAME 操作人,us.USERNAME 操作人2from SMTLINKSITEMATHISTORY s join SMTSITEFIXMATUPHISTORY i on s.MACHINESITECODE=i.MACHINESITECODEJOIN USERINFO u on s.EVENTUSER=u.USERIDJOIN USERINFO us on i.EVENTUSER=us.USERIDAND s.WORKORDER=i.BACKUP1 AND s.WORKORDERROW=i.BACKUP2and s.EVENTTIME<=i.EVENTTIMEand to_char(s.EVENTTIME,'YYYY-MM-DD hh24:mi:ss')>='2021-10-19 20:35:05'and to_char(s.EVENTTIME,'YYYY-MM-DD hh24:mi:ss')<='2021-10-20 08:35:05'and to_char(i.EVENTTIME,'YYYY-MM-DD hh24:mi:ss')>='2021-10-19 20:35:05'and to_char(i.EVENTTIME,'YYYY-MM-DD hh24:mi:ss')<='2021-10-20 08:35:05'and s.BACKUP1 like'%SMT-1%'and i.EVENTNAME like'%SMTMATUP%'group by s.MACHINECODE,s.MACHINENAME,s.MACHINETYPE,s.MACHINESITECODE,s.MACHINESITENAME,s.FGCODEVERSION,s.DESCRIPTION,s.FGCODE,s.FGKIND,s.WORKORDER,s.BACKUP4,s.EVENTTIME,s.EVENTUSER,i.MATERIALID,i.EVENTUSER,i.EVENTTIME,i.EVENTNAME,i.FIXTURENAME,i.BOXQTY,i.LASTQTY,u.USERNAME,us.USERNAMEorder by i.EVENTTIME asc搞一个这样的 我现在查出来的数据 他们看的人说不对 有问题 麻烦请各位大佬指点指点