Home Forums SQL Server 2008 SQL Server 2008 - General NEED HELP!!! UPDATING, DELETING, ETC. RE: NEED HELP!!! UPDATING, DELETING, ETC.
Steve Jones - SSC Editor
SSC Guru
Points: 734418
More actions
February 28, 2012 at 2:05 pm
#1452808
An update statement doesn't have a select. It should be like:
update a
set a.column = a.column + 1
from Table1 a
inner join table2 b
on a.Col2 = b.col2