Have you looked at the Unix command ‘join’? This is a cool tool, but I think join is pretty much everywhere.