sql更新字段值等于另一张表的值

UPDATE

`user_function_power`

LEFT JOIN `version_buy`

ON user_function_power.`enterprise_id` = version_buy.`enterprise_id`

AND user_function_power.`vcode`=version_buy.`vcode`

SET user_function_power.`endtime` = version_buy.`end_time`