join

To mixt a pair of files that have a common key.

Example:

Prompt> join file1 file2

This prints the content of file1 and file2 when the same key is found in their first columns.

Nota bene:
Keys need to be sorted in both files.