mssql Update from another table / 更新資料使用別的TABLE

引用來源
--

UPDATE TABLEA
SET (b, c, d) = (SELECT b1, c1, d1 from TABLEB WHERE TABLEB.a1 = TABLEA.a and TABLEB.e1 > 40)
WHERE EXISTS (SELECT 1 from TABLEB WHERE TABLEB.a1 = TABLEA.a and TABLEB.e1 > 40)

update (
select a.fileld, b.fileld
from TABLEA a, TABLE b
where 
a.key = b.key 

) set fileld = fileld