将数据库表1中actual_commission_balance的值修改到数据库表2中id为invite_user_id的balance中

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