检查车间收入是否有在PS有遗漏

---检查车间收入是否有在PS有遗漏
  select 组合码,生产线代码 into #SRZHM from 车间收入 WHERE 组合码 like '%M1'  AND CONVERT(date,操作时间)>'2024-02-25'
   AND 零件名称 <>'减震油'
  group by 组合码,生产线代码

  select #SRZHM.*,LSCKZD_CKBH into #SRZHM1 from #SRZHM,cwbase3.lc0019999.lsckzd where  生产线代码=LSCKZD_CKMC

  SELECT KCRKD1_PJLX,KCRKD1_LYBH, KCRKD1_CKBH,KCRKD1_C2 INTO #KCRKD  
  FROM  cwbase3.lc0019999.KCRKD1 WHERE KCRKD1_C2 LIKE '%M1' AND KCRKD1_KCYWRQ>'20240225'
  select * from #SRZHM1 where 组合码+LSCKZD_CKBH NOT IN(SELECT KCRKD1_C2+KCRKD1_CKBH  FROM #KCRKD)
  drop table #SRZHM
  drop table #SRZHM1
  DROP TABLE #KCRKD

  SELECT KCYXZ1_RKJZ, * FROM  cwbase3.lc0019999.KCYXZ1 WHERE KCYXZ1_C2='2403156533M1'
  SELECT  * FROM cwbase3.lc0019999.KCRKD1 WHERE KCRKD1_C2='2403156533M1'
   SELECT  * FROM cwbase3.lc0019999.KCCKD1 WHERE KCCKD1_C2='2403156533M1'

   select * from #SRZHM1 where 组合码='2403156442M1'