sql server - Update and left outer join statements - Stack Overflow

UPDATE md SET md.status = '3' FROM pd_mounting_details AS md ... Update t SET t.Column1=100 FROM myTableA t LEFT JOIN myTableB t2 ...

stackoverflow.com