————————————

SELECT

s.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 操作人2

FROM

SMTLINKSITEMATHISTORY s

JOIN SMTSITEFIXMATUPHISTORY i ON s.MACHINESITECODE = i.MACHINESITECODE

AND s.WORKORDER = i.BACKUP1

AND s.WORKORDERROW = i.BACKUP2

JOIN USERINFO u ON s.EVENTUSER = u.USERID

JOIN USERINFO us ON i.EVENTUSER = us.USERID

WHERE

EVENTTIME <= i.EVENTTIME

AND 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.USERNAME

ORDER BY

i.EVENTTIME ASC

估计是时间条件有问题，是哪里不对  你要自己对下哪里出了问题

不是 我想问没有聚合函数 为啥还要group by