sql update left

update Accounts 
       set functionpostid ='2AE52014-C9EB-4ECE-A514-156F30BA67CC'
from Accounts  a  
left join CommonFunctionPost b on a.functionpostid=b.c_id
where b.title='锦纶公司设备科科长'