UPDATE WITH JOIN PROBLEM

[Srdjan Josipovic]

Well , I think that this one is easy , but it look like I am a bit confused .     TABLE1   |-------------------|-------------------| |       ID         |  SYMBOL   | |-------------------|-------------------|   INTEGER         VARCHAR   about 1000 rows with unique ID and some value for SYMBOL   NOW I add a new column into TABLE2 >> SYMBOL and want to update it from TABLE1 referencing Column ID From TABLE1 FROM Column ID in TABLE2   SELECT TABLE1.SYMBOL  FROM  TABLE1,TABLE2 WHERE TABLE1.ID = TABLE2.ID     TABLE2   |-------------------|-------------------|-------------------| |        ID        |     DATE     |   SYMBOL   | |-------------------|-------------------|-------------------|   INTEGER       TimeStamp    VARCHAR           IN SQL SERVER UPDATE STATEMENT WILL BE  :   UPDATE TABLE2 SET SYMBOL = tbl1.SYMBOL FROM TABLE1 tbl1 INNER JOIN TABLE2 tbl2 ON tbl1.ID = tbl2.ID   But here ......in SAP ??   Can someone make this UPDATE Statement for SAP , Please .     Regards , Srdjan