机加方法变更处理

select  * from   KCRKD1,KCRKD2,LSWLZD WHERE KCRKD1_LSBH=KCRKD2_LSBH and KCRKD2_WLBH=LSWLZD_WLBH and LSWLZD_JJFF=6
and KCRKD2_JHDJ=0 and KCRKD2_WLBH='3B932080' and KCRKD1_CKBH like '01005'

update KCRKD2 set KCRKD2_JHDJ=KCRKD2_DJ,KCRKD2_JHJE=KCRKD2_JE
from   KCRKD1,KCRKD2,LSWLZD WHERE KCRKD1_LSBH=KCRKD2_LSBH and KCRKD2_WLBH=LSWLZD_WLBH and LSWLZD_JJFF=6
and KCRKD2_JHDJ=0 and KCRKD2_WLBH='3B932070' and KCRKD1_CKBH like '01002'