


      JJJJOOOOIIIINNNN((((1111))))                     ((((UUUUNNNNIIIIXXXX 5555....0000))))                    JJJJOOOOIIIINNNN((((1111))))



      NNNNAAAAMMMMEEEE
           join - relational database operator

      SSSSYYYYNNNNTTTTAAAAXXXX
           jjjjooooiiiinnnn [ options ] file1 file2

      DDDDEEEESSSSCCCCRRRRIIIIPPPPTTTTIIIIOOOONNNN
           _J_o_i_n forms, on the standard output, a join of the two
           relations specified by the lines of _f_i_l_e_1 and _f_i_l_e_2.  If
           _f_i_l_e_1 is ----, the standard input is used.

           _F_i_l_e_1 and _f_i_l_e_2 must be sorted in increasing ASCII collating
           sequence on the fields on which they are to be joined,
           normally the first in each line.

           There is one line in the output for each pair of lines in
           _f_i_l_e_1 and _f_i_l_e_2 that have identical join fields.  The output
           line normally consists of the common field, then the rest of
           the line from _f_i_l_e_1, then the rest of the line from _f_i_l_e_2.

           Fields are normally separated by blank, tab or new-line.  In
           this case, multiple separators count as one, and leading
           separators are discarded.

           These options are recognized:

           ----aaaa_n  In addition to the normal output, produce a line for
                each unpairable line in file _n, where _n is 1 or 2.

           ----eeee _s Replace empty output fields by string _s.

           ----jjjj_n _m
                Join on the _mth field of file _n.  If _n is missing, use
                the _mth field in each file.

           ----oooo _l_i_s_t
                Each output line comprises the fields specifed in _l_i_s_t,
                each element of which has the form _n...._m, where _n is a
                file number and _m is a field number.

           ----tttt_c  Use character _c as a separator (tab character).  Every
                appearance of _c in a line is significant.

      SSSSEEEEEEEE AAAALLLLSSSSOOOO
           awk(1), comm(1), sort(1).

      BBBBUUUUGGGGSSSS
           With default field separation, the collating sequence is
           that of ssssoooorrrrtttt ----bbbb; with ----tttt, the sequence is that of a plain
           sort. The conventions of _j_o_i_n, _s_o_r_t, _c_o_m_m, _u_n_i_q and _a_w_k(1)
           are inconsistent.




      Page 1                                                   (9010-E)






      JJJJOOOOIIIINNNN((((1111))))                     ((((UUUUNNNNIIIIXXXX 5555....0000))))                    JJJJOOOOIIIINNNN((((1111))))























































      Page 2                                                   (9010-E)






