TSQL: Update Select

Update statement using a select query as its source:
UPDATE Table1
SET Field1 = Table2.Field1
FROM Table2
WHERE Table1.ID = Table2.ID

2 comments:

BatMastersonJr said...

So, where's the SELECT?

BatMastersonJr said...

So, where's the SELECT?