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? Thanks Steve Fogelson Internet Commerce Solutions
