.\" Copyright (c) 1990 The Regents of the University of California.
.\" Redistribution and use in source and binary forms are permitted provided
.\" that: (1) source distributions retain this entire copyright notice and
.\" comment, and (2) distributions including binaries display the following
.\" acknowledgement: ``This product includes software developed by the
.\" University of California, Berkeley and its contributors'' in the
.\" documentation or other materials provided with the distribution and in
.\" all advertising materials mentioning features or use of this software.
.\" Neither the name of the University nor the names of its contributors may
.\" be used to endorse or promote products derived from this software without
.\" specific prior written permission.
.\" THIS SOFTWARE IS PROVIDED ``AS IS'' AND WITHOUT ANY EXPRESS OR IMPLIED
.\" WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
.\" MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
.\" @(#)join.1 6.3 (Berkeley) 7/24/90
.Nd relational database operator
.Op Fl j Ar file_number field
The join utility performs an ``equality join'' on the files
The joined files are written to the standard
The ``join field'' is a field in each file on which the
There is one line in the output for
The output line by default consists of the
join field, then the remaining fields from
This format can be changed by
The files file1 and file2 should be ordered in the collating
on the fields on which they are to be
joined, by default the first in each line; Otherwise, all
join field matches need not be reported.
The default input field separators are <blank>s.
case, multiple separators count as one field separator, and
leading separators are ignored.
The following options are available:
In addition to the default output, produce a line
for each unpairable line in file
Replace empty output fields by the string
first digit of the option argument is neither 1 nor
decimal integers starting with 1.
Each output line comprises the fields specified in
each element of which has the form
number and field is a decimal integer field number.
The elements of list are either comma or <space> separated.
The list is written only for lines with matching join fields,
and is not output unless specifically requested.
as a separator, for both input
Every appearance of char in a line is
When this option is specified, the
collating sequence should be the same as sort
Instead of the default output, produce a line only
for each unpairable line in
decimal integers starting with 1.
decimal integers starting with 1.
are specified, both sets of information
always first, regardless of the specified
The following arguments are required:
A pathname of a file to be joined.
input is used in its place.
utility exits 0 on success, and >0 if an error occurs.
function is expected to be POSIX 1003.2 compatible.