awk or sed one liner

view story

http://www.unix.com – I have a data base of part numbers: Code: AAA Thing1 BBB Thing2 CCC Thing3 File one is a list of part numbers: Code: XXXX AAA234 XXXX BBB678 XXXX CCC2345 Is there a sed one-line that would compare a data base with and replace the part numbers so that the output looks like this? Code: XXXX AAA234 Thing1 XXXX BBB678 Thing2 XXXX CCC2345 Thing3 Moderator's Comments: Please use code tags when posting data and code samples! (HowTos)