--检查电子-工时底数为1 请及时维护
--条件为在工单一个月内有生产过的产品
SQL:
SELECT MB001 品号,MB002 品名,MB003 规格,MB096 工时底数
FROM ZE.dbo.INVMB left join ZE.dbo.INVML on MB001=ML001 inner join (select distinct TA006 FROM ZE.dbo.MOCTA WHERE LEFT(TA003,6)=CONVERT(CHAR(6),GETDATE(),112)) MOCTA ON MB001=TA006 WHERE MB025='M' AND MB096=1 and MB002<>'' and left(MB001,1) not in('4','2') and MB017='03' AND ML009<>'' AND ZE.dbo.Producttype(MB001)=1 and MB001 in (select TA006 from MOCTA
WHERE DATEDIFF(day,ZE.dbo.Date10(TA003),getdate())<30)
SQL: