-- USE DB_Name
UPDATE Table_Name SET Table.Col = 'Value'
-- SELECT Table.Col1, Table2.Col2, Table3.Col3, Table.*
FROM Table_Name
LEFT JOIN Table2 WITH (NOLOCK) ON Table2.IDTab2 = Table.IDTab2
LEFT JOIN Table3 WITH (NOLOCK) ON Table3.IDTab3 = Table.IDTab3
[ WHERE <omezující podmínka>:
Table2.Col = 'Val2' AND Table3.Col = 'Val3' ]