SQL 更新数据库表数据：将 table1 的 actual_commission_balance 复制到 table2 的 balance

UPDATE table2 SET balance = (SELECT actual_commission_balance FROM table1 WHERE invite_user_id = table2.id) WHERE EXISTS (SELECT * FROM table1 WHERE invite_user_id = table2.id);