UPDATE t1 LEFT JOIN t2 SET t1.c1 = t2.c2 but that is not allowed in SAPDB. Is there any workaround?
Can't you use a sub query ?
I don't think so.
The grammer of the UPDATE statement says, that i'm only allowed to use a table-name. THe other problem is, that views with JOINs are not updatable either. So i guess there's no way of doing what i want - which is a pitty because i need to write my own code to transfer data from one table into another.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
