SQL Update table query with inner join

UPDATE ot SET ot.Description=h.headName +'-'+d.description FROM OrderTable ot INNER JOIN DescriptionTable d ON d.description=ot.Description INNER JOIN HeaderTable h ON h.id=d.headID ;


Thanks to
http://www.bennadel.com