[prev] [index] [next]

join: database operator

join merges two files using the values in a field in each file as a common key.

The key field can be in a different position in each file, but the files must be ordered on that field. The default key field is 1.

Some options:

-1 k key field in first file is k
-2 k key field in second file is k
-a N print a line for each unpairable line in file N (1 or 2)
-i ignore case
-t c tab character is c