I have three tables
orderstable contains the
old_user_loginand associated order number.
customer_oldtable contains the information on customer, namely
The idea is to replace the
new_user_login for all the rows in the
orders table, and the only thing that matches is the
user_fullname in the two customer tables. The old customer table will effectively be made redundant and deleted after this operation is done.
How do I go about doing this?