Hi,
This is a silly question, not that SAPDB specific I think, but I want to
do something like:
UPDATE
st
SET
st.field1 = ot.field1,
st.field2 = ot.field2
FROM
spiffy_table st,
other_table ot
WHERE
st.key=ot.key
Only SAPDB doesn't like the FROM clause... (I know, I know.. too much
ms-SQL-server...)
I am sure this can be done with a subquery, but have had a mental block on
exactly how... Any ideas?
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
