join — Relational Database Operator

Synopsis

/usr/bin/join [-a filenumber | -v filenumber] [-1 fieldnumber] 
  [-2 fieldnumber] [-o list] [-e string][-t char] file1 file2 
/usr/bin/join [-a filenumber] [-j fieldnumber][-j1 fieldnumber] 
  [-j2 fieldnumber][-o list] [-e string] [-t char] file1 file2
					

Description

The join command forms a join of the two relations specified by the lines of file1 and file2 and displays the result on standard output.

The output has one line for each pair of lines in file1 and file2 that have identical join fields. The output line normally consists of the common field, then the rest of the line from file1 , then the rest of the line from file2 . You can change this format with the -o option. Use the -a option to add unmatched ...

Get Solaris™ 7 Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.