update a
set a.approve_by = 'ZZ'
from appm_car_feet_card_h b , appr_car_fuel_expense_t a , appm_car_feet_card_type c
where a.feed_card_code = b.feed_card_code
and c.feed_card_type = b.feed_card_type
and a.approve_by = 'M02553' and c.feed_card_type = '1'
update appr_car_fuel_expense_t
set approve_by = 'ZZ'
where feed_card_code in (select a.feed_card_code
from appm_car_feet_card_h b , appr_car_fuel_expense_t a , appm_car_feet_card_type c
where a.feed_card_code = b.feed_card_code
and c.feed_card_type = b.feed_card_type
and a.approve_by = 'M02553' and c.feed_card_type = '1')
Load balance : Server 02
