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 f
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
whe
