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?)
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
