select update 방식

 BEGIN TRAN
 UPDATE A
    SET A.SALE_PRSN = '12'
-- SELECT  SALE_PRSN,order_num,*
  FROM sdft A   inner join sdf B   on a.comp_code = b.comp_code
                                                       and a.div_code  = b.div_code
                                                       and a.bill_num  = b.bill_num
 WHERE 1 = 1
   AND b.ORDER_NUM IN (
      '130218'
     )