https://gunkies.org/index.php?action=history&feed=atom&title=32v_1m_join 2026-06-04T11:21:08Z Revision history for this page on the wiki MediaWiki 1.30.1 https://gunkies.org/w/index.php?title=32v_1m_join&diff=6974&oldid=prev 2009-10-26T14:22:56Z

<p>New page: JOIN(1) UNIX Programmer&#039;s Manual JOIN(1) == NAME == join - relational database operator == SYNOPSIS == join [ options ] file1 file2 == DESCRIPTION =...</p> <p><b>New page</b></p><div>JOIN(1) UNIX Programmer's Manual JOIN(1)<br /> <br /> <br /> <br /> == NAME ==<br /> join - relational database operator<br /> <br /> == SYNOPSIS ==<br /> join [ options ] file1 file2<br /> <br /> == DESCRIPTION ==<br /> _J_o_i_n forms, on the standard output, a join of the two rela-<br /> tions specified by the lines of _f_i_l_e_1 and _f_i_l_e_2. If _f_i_l_e_1<br /> is `-', the standard input is used.<br /> <br /> _F_i_l_e_1 and _f_i_l_e_2 must be sorted in increasing ASCII collating<br /> sequence on the fields on which they are to be joined, nor-<br /> mally the first in each line.<br /> <br /> There is one line in the output for each pair of lines in<br /> _f_i_l_e_1 and _f_i_l_e_2 that have identical join fields. The output<br /> line normally consists of the common field, then the rest of<br /> the line from _f_i_l_e_1, then the rest of the line from _f_i_l_e_2.<br /> <br /> Fields are normally separated by blank, tab or newline. In<br /> this case, multiple separators count as one, and leading<br /> separators are discarded.<br /> <br /> These options are recognized:<br /> <br /> -a_n In addition to the normal output, produce a line for<br /> each unpairable line in file _n, where _n is 1 or 2.<br /> <br /> -e _s Replace empty output fields by string _s.<br /> <br /> -j_n _m<br /> Join on the _mth field of file _n. If _n is missing, use<br /> the _mth field in each file.<br /> <br /> -o _l_i_s_t<br /> Each output line comprises the fields specifed in _l_i_s_t,<br /> each element of which has the form _n._m, where _n is a<br /> file number and _m is a field number.<br /> <br /> -t_c Use character _c as a separator (tab character). Every<br /> appearance of _c in a line is significant.<br /> <br /> == SEE ALSO ==<br /> [[32v 1m sort|sort(1)]], [[32v 1m comm|comm(1)]], [[32v 1m awk|awk(1)]]<br /> <br /> BUGS<br /> With default field separation, the collating sequence is<br /> that of _s_o_r_t -_b; with -t, the sequence is that of a plain<br /> sort.<br /> <br /> The conventions of _j_o_i_n, _s_o_r_t, _c_o_m_m, _u_n_i_q, _l_o_o_k and _a_w_k(1)<br /> are wildly incongruous.<br /> <br /> [[Category:32v man section 1]]</div>

Neozeed