I have the following query -
update dbo.AllData$ t1
set t1.Con = (
from dbo.AllData$ t2
where t2.Log<121 and t2.Loc=t1.Loc
t1.Log > 120
But I got error:
Incorrect syntax near 't1'.
Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'where'.
I cannot locate where the problem is. I appreciate any help.