List:General Discussion« Previous MessageNext Message »
From:DebugasRu Date:August 5 2004 11:22am
Subject:updating table based on other table values
View as plain text  
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)

index PID+PAJ is unique both for tmpISM and ta
Any suggestions how the update should look like (i suspect it will
have to have sub-select)


Thread
updating table based on other table valuesDebugasRu5 Aug
  • Re: updating table based on other table valuesPhilippe Poelvoorde5 Aug
    • Re[2]: updating table based on other table valuesDebugasRu5 Aug
      • Re[3]: updating table based on other table valuesDebugasRu5 Aug
      • Re: updating table based on other table valuesPhilippe Poelvoorde5 Aug
  • Re: updating table based on other table valuesSGreen5 Aug