Return to join.1 CVS log

Up to [Power 6/32 Unix Tahoe 4.2BSD] / cci / usr / src / man / man1

Annotation of cci/usr/src/man/man1/join.1, revision 1.1.1.1

1.1       root        1: .TH JOIN 1 "18 January 1983" 
                      2: .SH NAME
                      3: join \- relational database operator
                      4: .SH SYNOPSIS
                      5: .B join
                      6: [
                      7: options
                      8: ]
                      9: file1 file2
                     10: .SH DESCRIPTION
                     11: .I Join
                     12: forms, on the standard output,
                     13: a join
                     14: of the two relations specified by the lines of
                     15: .I file1
                     16: and
                     17: .IR file2 .
                     18: If
                     19: .I file1
                     20: is `\-', the standard input is used.
                     21: .PP
                     22: .I File1
                     23: and 
                     24: .I file2
                     25: must be sorted in increasing ASCII collating
                     26: sequence on the fields
                     27: on which they are to be joined,
                     28: normally the first in each line.
                     29: .PP
                     30: There is one line in the output 
                     31: for each pair of lines in 
                     32: .I file1 
                     33: and 
                     34: .I file2
                     35: that have identical join fields.
                     36: The output line normally consists of the common field,
                     37: then the rest of the line from 
                     38: .IR file1 ,
                     39: then the rest of the line from
                     40: .IR file2 .
                     41: .PP
                     42: Fields are normally separated by blank, tab or newline.
                     43: In this case, multiple separators count as one, and
                     44: leading separators are discarded.
                     45: .PP
                     46: These options are recognized:
                     47: .TP
                     48: .BI \-a n
                     49: In addition to the normal output,
                     50: produce a line for each unpairable line in file
                     51: .IR n ,
                     52: where
                     53: .I n
                     54: is 1 or 2.
                     55: .TP
                     56: .BI \-e \ s
                     57: Replace empty output fields by string
                     58: .IR s .
                     59: .TP
                     60: .BI \-j n\ m
                     61: Join on the
                     62: .IR m th
                     63: field of file
                     64: .IR n .
                     65: If
                     66: .I n
                     67: is missing, use the
                     68: .IR m th
                     69: field in each file.
                     70: .TP
                     71: .BI \-o \ list
                     72: Each output line comprises the fields specified in
                     73: .IR list ,
                     74: each element of which has the form
                     75: .IR n . m ,
                     76: where
                     77: .I n
                     78: is a file number and
                     79: .I m
                     80: is a field number.
                     81: .PP
                     82: .TP
                     83: .BI \-t c
                     84: Use character
                     85: .I c
                     86: as a separator (tab character).
                     87: Every appearance of
                     88: .I c
                     89: in a line is significant.
                     90: .SH "SEE ALSO"
                     91: sort(1), comm(1), awk(1)
                     92: .SH BUGS
                     93: With default field separation,
                     94: the collating sequence is that of
                     95: .IR sort\ \-b ;
                     96: with
                     97: .BR \-t ,
                     98: the sequence is that of a plain sort.
                     99: .PP
                    100: The conventions of
                    101: .I join, sort, comm, uniq, look
                    102: and
                    103: .IR awk (1)
                    104: are wildly incongruous.

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.