业务类别错误修订

select * from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063'
 AND kcrkd1_lbbh='02' AND KCRKD2_TSKC='Z'

select * from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063'
 AND kcrkd1_lbbh='01' AND KCRKD2_TSKC='K'


  update KCRKD1 set kcrkd1_lbbh='01'  from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063'
 AND kcrkd1_lbbh='02' AND KCRKD2_TSKC='Z'

 update KCRKD1 set kcrkd1_lbbh='02'  from KCRKD1 ,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBH --AND KCRKD1_SJDH='G240427000063'
 AND kcrkd1_lbbh='01' AND KCRKD2_TSKC='K'