join.1 (2010 09)

j
join(1) join(1)
EXAMPLES
The following command line joins the password file and the group file, matching on the numeric group
ID,
and outputting the login name, the group name, and the login directory. It is assumed that the files have
been sorted in the collating sequence defined by the
LC_COLLATE or LANG environment variable on the
group
ID fields.
join -1 4 -2 3 -o 1.1 2.1 1.6 -t: /etc/passwd /etc/group
The following command produces an output consisting all possible combinations of lines that have identi-
cal first fields in the two sorted files sf1 and sf2 , with each line consisting of the first and third fields from
sorted_file1 and the second and fourth fields from
sorted_file2:
join -j1 1 -j2 1 -o 1.1,2.2,1.3,2.4 sorted_file1 sorted_file2
WARNINGS
With default field separation, the collating sequence is that of
sort -b; with -t, the sequence is that of
a plain sort.
The conventions of
join, sort, comm
, uniq, and awk are incongruous.
Numeric filenames may cause conflict when the
-o option is used immediately before listing filenames.
AUTHOR
join was developed by OSF and HP.
SEE ALSO
awk(1), comm(1), sort(1), uniq(1).
STANDARDS CONFORMANCE
join: SVID2, SVID3, XPG2, XPG3, XPG4, POSIX.2
2 Hewlett-Packard Company − 2 − HP-UX 11i Version 3: September 2010