Script Comotan
Just for sharing my knowledge in my mind
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 )
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)