I don't know much about sapdb yet.
I have just read the documentation so far, and before installing it, I just
wanted to know something.
Using sql, I use very often this kind of sql statement:
UPDATE table1
SET table1.colA = table2.colAA
table1.colB = table2.colBB
table1.colC = table2.colCC
FROM table2
WHERE table1.col1 = table2.col2
This sql statement updates columns "colA", "colB" and "colC" of "table1"
based on values of colums "colAA", "colBB" and "colCC" of the joined table
"table2".
It works on MS SQL Server, and this syntax seems to be valid on postgresql
and db2, as far as I know.
Does it works on sapdb ?
( I browsed the documentation, and it seems that this syntax is not
accepted. That's why I ask to be sure ...)
If not, what sql statements do you use to achieve the same result with sap
db ?
Best Regards
**********************************************************************
This message is being transmitted to you without prior inspection
by Geneva Insurance.
The message engages only the person who authored it and in
no way is binding on Geneva Insurance.
The latter can under no circumstances be held responsible
for the contents of this message, neither contractually nor in
any other manner.
If the case arises, any commitments made by the author of
this message in the name of Geneva Insurance have no legal
validity unless confirmed in a letter duly signed by persons
authorized to represent the company.
[EMAIL PROTECTED]
**********************************************************************
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
