Return to join.1 CVS log

Up to [CSRG BSD Unix] / 43BSDTahoe / man / man1

Annotation of 43BSDTahoe/man/man1/join.1, revision 1.1

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

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