UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround?
You could try a INSERT ... SELECT ... UPDATE DUPLICATES
Well, i cannot use that as long as SAPDB replaces the whole row instead of doing an update. (how about renaming that to REPLACE DUPLICATES and how about offering a real UPDATE DUPLICATES?)
Shouldn't it be possible to use a join between t1 and t2 as the SELECT? Then you're free to choose the existing values from t1 for some columns and values from t2 for the rest.
Daniel Dittmar
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
