Srdjan Josipovic wrote:
> 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 .
Use:
UPDATE TABLE2
SET SYMBOL = (
SELECT TBL1.SYMBOL
FROM TABLE1 TBL1
WHERE TBL1.ID = TABLE2.ID
)
Elke
SAP Labs Berlin!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
