1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
|
<head>
<title>join(1) - Plan 9 from User Space</title>
<meta content="text/html; charset=utf-8" http-equiv=Content-Type>
</head>
<body bgcolor=#ffffff>
<table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr height=10><td>
<tr><td width=20><td>
<tr><td width=20><td><b>JOIN(1)</b><td align=right><b>JOIN(1)</b>
<tr><td width=20><td colspan=2>
<br>
<p><font size=+1><b>NAME </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
join – relational database operator<br>
</table>
<p><font size=+1><b>SYNOPSIS </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
<tt><font size=+1>join</font></tt> [ <i>options</i> ] <i>file1 file2<br>
</i>
</table>
<p><font size=+1><b>DESCRIPTION </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
<i>Join</i> forms, on the standard output, a join of the two relations
specified by the lines of <i>file1</i> and <i>file2</i>. If one of the file
names is <tt><font size=+1>−</font></tt>, the standard input is used.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
<i>File1</i> and <i>file2</i> must be sorted in increasing ASCII collating sequence
on the fields on which they are to be joined, normally the first
in each line.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
There is one line in the output for each pair of lines in <i>file1</i>
and <i>file2</i> that have identical join fields. The output line normally
consists of the common field, then the rest of the line from <i>file1</i>,
then the rest of the line from <i>file2</i>.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
Input fields are normally separated spaces or tabs; output fields
by space. In this case, multiple separators count as one, and
leading separators are discarded.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
The following options are recognized, with POSIX syntax.<br>
<tt><font size=+1>−a</font></tt> <i>n</i> In addition to the normal output, produce a line for each
unpairable line in file <i>n</i>, where <i>n</i> is 1 or 2.<br>
<tt><font size=+1>−v</font></tt> <i>n</i> Like <tt><font size=+1>−a</font></tt>, omitting output for paired lines.<br>
<tt><font size=+1>−e</font></tt> <i>s</i> Replace empty output fields by string <i>s</i>.<br>
<tt><font size=+1>−1</font></tt> <i>m<br>
</i><tt><font size=+1>−2</font></tt> <i>m</i> Join on the <i>m</i>th field of <i>file1</i> or <i>file2</i>.<br>
<tt><font size=+1>−j</font></tt><i>n m<br>
</i>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
Archaic equivalent for <tt><font size=+1>−</font></tt><i>n</i> <tt><font size=+1>m</font></tt>.<br>
</table>
<tt><font size=+1>−o</font></tt><i>fields<br>
</i>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
Each output line comprises the designated fields. The comma-separated
field designators are either <tt><font size=+1>0</font></tt>, meaning the join field, or have
the form <i>n</i>.<i>m</i>, where <i>n</i> is a file number and <i>m</i> is a field number.
Archaic usage allows separate arguments for field designators.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
</table>
<tt><font size=+1>−t</font></tt><i>c</i> Use character <i>c</i> as the only separator (tab character) on input
and output. Every appearance of <i>c</i> in a line is significant.<br>
</table>
<p><font size=+1><b>EXAMPLES </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
<tt><font size=+1>sort /etc/passwd | join −t: −1 1 −a 1 −e "" − bdays<br>
</font></tt>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
Add birthdays to the <tt><font size=+1>/etc/passwd</font></tt> file, leaving unknown birthdays
empty. The layout of <tt><font size=+1>/adm/users</font></tt> is given in <a href="../man5/passwd.html"><i>passwd</i>(5)</a>; <tt><font size=+1>bdays</font></tt> contains
sorted lines like <tt><font size=+1>ken:Feb 4, 1953</font></tt>.<br>
</table>
<tt><font size=+1>tr : ' ' </etc/passwd | sort −k 3 3 >temp<br>
join −1 3 −2 3 −o 1.1,2.1 temp temp | awk '$1 < $2'<br>
</font></tt>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
Print all pairs of users with identical userids.<br>
</table>
</table>
<p><font size=+1><b>SOURCE </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
<tt><font size=+1>/usr/local/plan9/src/cmd/join.c<br>
</font></tt>
</table>
<p><font size=+1><b>SEE ALSO </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
<a href="../man1/sort.html"><i>sort</i>(1)</a>, <a href="../man1/comm.html"><i>comm</i>(1)</a>, <a href="../man1/awk.html"><i>awk</i>(1)</a><br>
</table>
<p><font size=+1><b>BUGS </b></font><br>
<table border=0 cellpadding=0 cellspacing=0><tr height=2><td><tr><td width=20><td>
With default field separation, the collating sequence is that
of <tt><font size=+1>sort −b −k</font></tt><i>y</i><tt><font size=+1>,</font></tt><i>y</i>; with <tt><font size=+1>−t</font></tt>, the sequence is that of <tt><font size=+1>sort −t</font></tt><i>x</i> <tt><font size=+1>−k</font></tt><i>y</i><tt><font size=+1>,</font></tt><i>y</i>.
<table border=0 cellpadding=0 cellspacing=0><tr height=5><td></table>
One of the files must be randomly accessible.<br>
</table>
<td width=20>
<tr height=20><td>
</table>
<!-- TRAILER -->
<table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr height=15><td width=10><td><td width=10>
<tr><td><td>
<center>
<a href="../../"><img src="../../dist/spaceglenda100.png" alt="Space Glenda" border=1></a>
</center>
</table>
<!-- TRAILER -->
</body></html>
|