Thursday, December 23, 2010

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 )