根据某张表更新另一张表字段

语法：
UPDATE TABLE_A SET (field_1,field2) = (SELECT field_1,field2 FROM TABLE_B WHERE TABLE_B.id = TABLE_A.id);

示例：
UPDATE sys_log SET ( org_id ) = ( SELECT org_id FROM base_org WHERE base_org.org_no = sys_log.org_no )