select a.MB001,a.UDF51 as 毛重,b.UDF51,a.UDF52 as 单重,b.UDF52,a.UDF53 as 水口,b.UDF53,a.UDF01 as 模号,b.UDF01,a.UDF54 as 穴口,b.UDF54,a.UDF02 as 机台,b.UDF02,a.UDF03 as 周期,b.UDF03,a.MB004 as 单位,b.MB004 from wu a,(select MB001,MB002,MB003,UDF51,UDF52,UDF53,UDF01,UDF54,UDF02,UDF03,MB004 from INVMB where MB001 in(select MB001 from wu)) b where replace(a.MB001,' ','')=replace(b.MB001,' ','') --系统料号
and
(
--a.MB002!=b.MB002 --品名
a.MB003!=b.MB003 --规格
or a.UDF51!=b.UDF51 --毛重
or a.UDF52!=b.UDF52 --单重
or a.UDF53!=b.UDF53 --水口
or a.UDF01!=b.UDF01 --模号
or a.UDF54!=b.UDF54 --穴口
or a.UDF02!=b.UDF02 --机台
or a.UDF03!=b.UDF03 --周期
or a.MB004!=b.MB004 --单位
)
and a.MB001='366-001002-001'
--group by a.MB001 having count(1) >1;