In my example i have two tables as follows
and another one which has the role of a convserion table (lets call it to_change)
i want to build an update statatement which will replace old_aei with new_aei in ypotrh
table (aei column) where aei=old_aei. Please bear in mind that to_change table may contain more than one rows , so the update process should be executed for every line of to_change table.
Thanks very much