I need to update a table with 7000000 of registers and currently I am taking data with a select from two table and then update a third table with this info, and I do this on a loop in order to make sure that I have all the registries on the third table updated. Is there any other wat to do this process faster.

Thank you

write an update statement that is a join between the tables