DebugasRu wrote:
PP> try: PP> update tmpISM,ta PP> set tmp.SUMA=tmp.SUMA-ta.SUMA PP> where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ)
Does update work on more than one table ?
Yes you can : http://dev.mysql.com/doc/mysql/en/UPDATE.html
thank you for your input but i've just resolved the problem as follows (i have had forgotten the EXISTS keyword for a moment):
update tmp set tmp.SUMA=tmp.SUMA-ta.SUMA where exists ( select * from tmp,ta where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ) )
Cool, I didn't it exists :)
-- 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]
