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