SqlServer 關聯更新語句:

update a 
set a.pname = b.name
from 表a a 
inner join 表b b on a.pid = b.id

MySQL 關聯更新語句

UPDATE 表s s
LEFT JOIN 表j j
ON s.uid = j.id
set s.v_name = j.s_name;