MySQL update select

UPDATE
sheet1 AS dest,
(
SELECT
id,tyshxxdm
FROM
tab_qyzcxx
) AS src
SET
dest.qyid = src.id
where dest.统一社会信用代码 = src.tyshxxdm