Friday, June 15, 2012

Inner Join Update Query


How to write inner join in update query T-SQL
---------------------------------------------------------------------------------------------------------

//Syntax:
Update Table1 set columnName = pt.columnName
from Table1 d
inner join Table2 pt on d.columnName = pt.ColumnName

No comments:

Post a Comment