Subject Update with Join
Author Mr. John
Hi ! I was looking over this group to solve my problem but I didn't find the
answer :(
I want to update a field on a table using a join,something like this :

UPDATE table1 T1 INNER JOIN table2 T2
ON T1.fld1 = T2.fld1 and T1.fld2 = T2.fld2
SET T1.value = 10 WHERE T2.fld3 = 1000

but it gives me
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, column 30.

Thanks !

[Non-text portions of this message have been removed]