> >>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 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]
