Pattern of writing UPDATE query based on SELECT Query

update-on-select.md

Pattern:

UPDATE
    `table1` AS `dest`,
    (
        SELECT
            *
        FROM
            `table2`
        WHERE
            `id` = x
    ) AS `src`
SET
    `dest`.`col1` = `src`.`col1`
WHERE
    `dest`.`id` = x
;

Instance:

UPDATE 
	yl_inpatient_vital_sign AS dest,
	(
	 	SELECT 
			id,inpatient_no 
	 	FROM 
			yl_inpatient
	 ) AS src
SET 
	dest.inpatient_id = src.id 
WHERE 
	dest.`inpatient_no` = src.inpatient_no
;

Source

• https://stackoverflow.com/a/1262848