Command Reference Guide

__________________________________________________________________________________________________________________________________________________________________________________________________
__________________________________________________________________________________________________________________________________________________________________________________________________
STANDARD Printed by: Nora Chuang [nchuang] STANDARD
/build/1111/BRICK/man1/!!!intro.1
________________________________________________________________
___ ___
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 identical
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
HP-UX Release 11i: December 2000 − 2 − Section 1−−365
___
___