sql update多表关联更新

-- 方法1
UPDATE b 
    SET b.status= 1 
FROM
    t_bed_adapter b, t_adapter a
WHERE
    a.id = b.adapter_id AND a.dept_code = '214'

-- 方法2
UPDATE b 
    SET b.status = 1 
FROM
    t_bed_adapter b
    LEFT JOIN t_adapter a ON a.id = b.adapter_id 
WHERE
    a.dept_code = '214'