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'