I take out the loop, and index both tables on the matching criteria in the where clause but when I run the updates nothing except one record updates. When I run the update in the loop everything updates properly.