update dbo.sm_check set BORR_QUAN = (select dbo.sm_check.BORR_QUAN+C.QUANTITY from dbo.SM_borrow B,dbo.SM_borrow_detail C where dbo.sm_check.mate_code=C.mate_code and B.BORR_NO=C.BORR_NO and B.RETU_FLAG<>'2'), BORR_AMOUNT= (select dbo.sm_check.BORR_AMOUNT+C.AMOUNT from dbo.SM_borrow B,dbo.SM_borrow_detail C where dbo.sm_check.mate_code=C.mate_code and B.BORR_NO=C.BORR_NO and B.RETU_FLAG<>'2')
set BORR_QUAN =
(select dbo.sm_check.BORR_QUAN+C.QUANTITY
from dbo.SM_borrow B,dbo.SM_borrow_detail C
where dbo.sm_check.mate_code=C.mate_code
and B.BORR_NO=C.BORR_NO
and B.RETU_FLAG<>'2'),
BORR_AMOUNT=
(select dbo.sm_check.BORR_AMOUNT+C.AMOUNT
from dbo.SM_borrow B,dbo.SM_borrow_detail C
where dbo.sm_check.mate_code=C.mate_code
and B.BORR_NO=C.BORR_NO
and B.RETU_FLAG<>'2')