select count(*),b.COMPONENT_NAME,t.COL23,t.COL24 from buyer_component b ,buyer_component_ext t
where b.BUYER_COMPONENT_ID=t.BUYER_COMPONENT_EXT_ID
group by b.COMPONENT_NAME,t.COL23,t.COL24 having count(*)>1;
查询物料中,物料名,零件图号,车型均相同的重复物料!
最新推荐文章于 2022-06-27 08:00:00 发布