I am pretty new to SQL and I already read something about joins , but coudn't find out. I painted my scenario here :
I want to update the Firstname of Table1 into Temp1 where the CreateTS of the matching ID in Table2 is < 08.02.2014
for that I need a join but can't solve it. Any Tips are welcome..
update Table1
set Firstname = 'Temp1'
where Firstame = 'xxx'
join Table
and CreateTS < '2014-02-08 15:00:00.000'