Table name: Table1
Way 1: use full table name instead of alias
update Table1
set c1=XXX
from Table1 t1 inner join Table1
on Table.c1=t1.c1
where XXX
Way 2:
update T2
set c1=XXX
from Table t1 inner join Table t2
on t1.c1=t2.c1
where XXX