update Accounts
set functionpostid =b.c_id --'2AE52014-C9EB-4ECE-A514-156F30BA67CC'
from Accounts a
left join CommonFunctionPost b on a.functionpostid=b.c_id
where b.title='锦纶公司设备科科长'
sql update left
于 2022-01-21 10:11:24 首次发布