Update Table

Update Table (Source Data from other table)

UPDATE mu

SET rt_id = (

SELECT rt_id

FROM billing_info

WHERE billing_info.ms = mu.ms )

WHERE EXISTS (

SELECT 1

FROM billing_info

WHERE billing_info.ms = mu.ms )