update left join

Update t 
SET 
       t.Column1=100
FROM 
       myTableA t 
LEFT JOIN 
       myTableB t2 
ON 
       t2.ID=t.ID

fuente: https://stackoverflow.com/questions/6335388/update-and-left-outer-join-statements