Home

Tags

UPDATE и JOIN (SQL)

2010-04-12 mssql sql

mssql

UPDATE Table1 Set Field1 = Value

FROM Table1 as t1

INNER JOIN Table2 as t2 on t1.Field2 = t2.Field2

WHERE Field3 = Value