DebugasRu wrote:
Hello i can't figure out how to update the table tmpISM based on other table ta values. What i need i can intuitivly express as follows:
update tmpISM set tmp.SUMA=tmp.SUMA-ta.SUMA where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ)
try:
update tmpISM,ta set tmp.SUMA=tmp.SUMA-ta.SUMA where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ)
-- Philippe Poelvoorde COS Trading Ltd.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
