UPDATE table1 + SET var1 = t2.var4, + var2 = t2.var5, + var3 = t2.var6 + FROM table1 t1, table2 t2 + WHERE (t1.ID = t2.ID)
Bill On Mon, 6 Oct 2003 20:05:39 -0500, Fogelson, Steve wrote: >Another piece of the puzzle. >I have 2 tables >Table1 >ID >Var1 >Var2 >Var3 >Table2 >ID >Var4 >Var5 >Var6 >I want to update Table 1 with the values from Table 2. Var1=Var4, Var2 =Var5, >Var3=Var6. Each ID in Table2 equals an ID in Table 1. >I could rename Var4, Var5, and Var6 to Var1, Var2, and Var3 if that would >make it easier. >What is the best way to accomplish this?
