in reply to Replace data in the column of one file with corresponding ones in another file
That looks to me like a good place to start. It should provide you with the ability to do what you want just using standard SQL statements.
(Note: I have not used this particular module, but now that I take a look, I think I might soon)
|
|---|