SCRIPT TO ADD DATA TO TBL 1 FROM TBL 2 WHERE. . . 1

[awise]

I need help with a script to add data (update) table 1 from table 2 where field 1 in table 1 = field 1 in table 2.

The records in table 2 already exist in table 1, I just want to add values from specified fields in table 2 to same specified fields in table 1.

Appreciate any assistance,

zaw

 

[gmmastros]

Generically, here is how this is done.

Update Table1
Set    Table1.Field = Table2.Field
From   Table1
       Inner Join Table2 
         On Table1.SomeField = Table2.SomeField

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom