summaryrefslogtreecommitdiffstats
path: root/www/syntax/table-or-subquery.html
blob: b31a368d06d05a3b6ed497050ffc0d0280018652 (plain)
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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
<!DOCTYPE html>
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Syntax: table-or-subquery</title>
<!-- path=../ -->
</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
<div class="tagline desktoponly">
Small. Fast. Reliable.<br>Choose any three.
</div>
<div class="menu mainmenu">
<ul>
<li><a href="../index.html">Home</a>
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
<li class='wideonly'><a href='../about.html'>About</a>
<li class='desktoponly'><a href="../docs.html">Documentation</a>
<li class='desktoponly'><a href="../download.html">Download</a>
<li class='wideonly'><a href='../copyright.html'>License</a>
<li class='desktoponly'><a href="../support.html">Support</a>
<li class='desktoponly'><a href="../prosupport.html">Purchase</a>
<li class='search' id='search_menubutton'>
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
</ul>
</div>
<div class="menu submenu" id="submenu">
<ul>
<li><a href='../about.html'>About</a>
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="../search">
<select name="s" id="searchtype">
<option value="d">Search Documentation</option>
<option value="c">Search Changelog</option>
</select>
<input type="text" name="q" id="searchbox" value="">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
var w = document.getElementById(nm);
if( w.style.display=="block" ){
w.style.display = "none";
}else{
w.style.display = "block";
}
}
function toggle_search() {
var w = document.getElementById("searchmenu");
if( w.style.display=="block" ){
w.style.display = "none";
} else {
w.style.display = "block";
setTimeout(function(){
document.getElementById("searchbox").focus()
}, 30);
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){
x.style.display = 'none';
b.innerHTML='show';
}else{
x.style.display = '';
b.innerHTML='hide';
}
return false;
}
var antiRobot = 0;
function antiRobotGo(){
if( antiRobot!=3 ) return;
antiRobot = 7;
var j = document.getElementById("mtimelink");
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
}
function antiRobotDefense(){
document.body.onmousedown=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousedown=null;
}
document.body.onmousemove=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousemove=null;
}
setTimeout(function(){
antiRobot |= 1;
antiRobotGo();
}, 100)
antiRobotGo();
}
antiRobotDefense();
</script>
<h1 align='center'>table-or-subquery</h1>
<div class='imgcontainer'>
<div style="max-width:720px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 720.778 457.704">
<circle cx="5" cy="36" r="3.6"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,74 39,78 39,70" style="fill:rgb(0,0,0)"/>
<path d="M9,36 L 16,36 Q 24,36 24,51 L 24,59 Q 24,74 34,74 L 45,74"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M66,89L162,89A15 15 0 0 0 177 74L177,74A15 15 0 0 0 162 59L66,59A15 15 0 0 0 50 74L50,74A15 15 0 0 0 66 89Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="114" y="74" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text>
<polygon points="194,74 183,78 183,70" style="fill:rgb(0,0,0)"/>
<path d="M177,74L189,74"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M209,89A15 15 0 0 0 225 74L225,74A15 15 0 0 0 209 59A15 15 0 0 0 194 74L194,74A15 15 0 0 0 209 89Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="209" y="74" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text>
<polygon points="266,36 255,41 255,32" style="fill:rgb(0,0,0)"/>
<path d="M225,74 L 232,74 Q 240,74 240,59 L 240,51 Q 240,36 250,36 L 260,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M281,51L356,51A15 15 0 0 0 371 36A15 15 0 0 0 356 21L281,21A15 15 0 0 0 266 36A15 15 0 0 0 281 51Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="319" y="36" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text>
<polygon points="407,36 396,41 396,32" style="fill:rgb(0,0,0)"/>
<path d="M371,36L402,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M423,51L427,51A15 15 0 0 0 442 36A15 15 0 0 0 427 21L423,21A15 15 0 0 0 407 36A15 15 0 0 0 423 51Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="425" y="36" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text>
<polygon points="478,36 466,41 466,32" style="fill:rgb(0,0,0)"/>
<path d="M442,36L472,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M493,51L561,51A15 15 0 0 0 577 36A15 15 0 0 0 561 21L493,21A15 15 0 0 0 478 36A15 15 0 0 0 493 51Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="527" y="36" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-alias</text>
<path d="M9,36L255,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="422,6 411,10 411,2" style="fill:rgb(0,0,0)"/>
<path d="M371,36 L 379,36 Q 386,36 386,21 L 386,21 Q 386,6 401,6 L 402,6 L 417,6"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M422,6 L 442,6 Q 457,6 457,21 L 457,21 Q 457,36 464,36 L 472,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M422,6 L 577,6 Q 592,6 592,21 L 592,21 Q 592,36 599,36 L 607,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M323,127L388,127A15 15 0 0 0 403 112A15 15 0 0 0 388 97L323,97A15 15 0 0 0 308 112A15 15 0 0 0 323 127Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="356" y="112" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INDEXED</text>
<polygon points="426,112 415,116 415,108" style="fill:rgb(0,0,0)"/>
<path d="M403,112L420,112"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M441,127L445,127A15 15 0 0 0 460 112A15 15 0 0 0 445 97L441,97A15 15 0 0 0 426 112A15 15 0 0 0 441 127Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="443" y="112" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">BY</text>
<polygon points="483,112 472,116 472,108" style="fill:rgb(0,0,0)"/>
<path d="M460,112L478,112"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M499,127L577,127A15 15 0 0 0 592 112A15 15 0 0 0 577 97L499,97A15 15 0 0 0 483 112A15 15 0 0 0 499 127Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="538" y="112" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">index-name</text>
<path d="M323,165L343,165A15 15 0 0 0 359 150A15 15 0 0 0 343 135L323,135A15 15 0 0 0 308 150A15 15 0 0 0 323 165Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="333" y="150" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text>
<polygon points="382,150 370,154 370,145" style="fill:rgb(0,0,0)"/>
<path d="M359,150L376,150"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M397,165L461,165A15 15 0 0 0 476 150A15 15 0 0 0 461 135L397,135A15 15 0 0 0 382 150A15 15 0 0 0 397 165Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="429" y="150" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">INDEXED</text>
<polygon points="527,74 539,70 539,78" style="fill:rgb(0,0,0)"/>
<path d="M577,36 L 607,36 Q 622,36 622,51 L 622,59 Q 622,74 607,74 L 548,74 L 533,74"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="308,150 297,154 297,145" style="fill:rgb(0,0,0)"/>
<path d="M527,74 L 297,74 Q 282,74 282,89 L 282,135 Q 282,150 292,150 L 302,150"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="308,112 297,116 297,108" style="fill:rgb(0,0,0)"/>
<path d="M282,97 L 282,104 Q 282,112 292,112 L 302,112"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="266,213 255,217 255,209" style="fill:rgb(0,0,0)"/>
<path d="M9,36 L 16,36 Q 24,36 24,51 L 24,198 Q 24,213 39,213 L 245,213 L 260,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M281,228L431,228A15 15 0 0 0 446 213A15 15 0 0 0 431 198L281,198A15 15 0 0 0 266 213A15 15 0 0 0 281 228Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="356" y="213" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-function-name</text>
<polygon points="463,213 452,217 452,209" style="fill:rgb(0,0,0)"/>
<path d="M446,213L457,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M478,228A15 15 0 0 0 493 213A15 15 0 0 0 478 198A15 15 0 0 0 463 213A15 15 0 0 0 478 228Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="478" y="213" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="529,213 518,217 518,209" style="fill:rgb(0,0,0)"/>
<path d="M493,213L524,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M529,228L579,228L579,198L529,198Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="554" y="213" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="615,213 603,217 603,209" style="fill:rgb(0,0,0)"/>
<path d="M579,213L609,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M630,228A15 15 0 0 0 645 213A15 15 0 0 0 630 198A15 15 0 0 0 615 213A15 15 0 0 0 630 228Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="630" y="213" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="675,187 679,198 671,198" style="fill:rgb(0,0,0)"/>
<path d="M645,213 L 660,213 Q 675,213 675,203 L 675,192"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M554,190A15 15 0 0 0 569 175A15 15 0 0 0 554 160A15 15 0 0 0 539 175A15 15 0 0 0 554 190Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="554" y="175" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="569,175 581,171 581,180" style="fill:rgb(0,0,0)"/>
<path d="M579,213 L 586,213 Q 594,213 594,198 L 594,190 Q 594,175 584,175 L 575,175"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M539,175 L 518,175 Q 503,175 503,190 L 503,198 Q 503,213 510,213 L 518,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M225,74 L 232,74 Q 240,74 240,89 L 240,198 Q 240,213 247,213 L 255,213"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="660,112 648,116 648,108" style="fill:rgb(0,0,0)"/>
<path d="M592,112L654,112"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M660,112 L 667,112 Q 675,112 675,104 L 675,97"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="660,150 648,154 648,145" style="fill:rgb(0,0,0)"/>
<path d="M476,150L654,150"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M660,150 L 667,150 Q 675,150 675,142 L 675,135"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M577,36L690,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M407,304L411,304A15 15 0 0 0 426 289A15 15 0 0 0 411 274L407,274A15 15 0 0 0 392 289A15 15 0 0 0 407 304Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="409" y="289" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text>
<polygon points="498,289 487,293 487,284" style="fill:rgb(0,0,0)"/>
<path d="M426,289L492,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M513,304L582,304A15 15 0 0 0 597 289A15 15 0 0 0 582 274L513,274A15 15 0 0 0 498 289A15 15 0 0 0 513 304Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="548" y="289" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-alias</text>
<polygon points="660,289 648,293 648,284" style="fill:rgb(0,0,0)"/>
<path d="M597,289L654,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M660,289 L 667,289 Q 675,289 675,281 L 675,274"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="548,251 559,247 559,255" style="fill:rgb(0,0,0)"/>
<path d="M645,213 L 652,213 Q 660,213 660,228 L 660,236 Q 660,251 645,251 L 568,251 L 553,251"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="392,289 380,293 380,284" style="fill:rgb(0,0,0)"/>
<path d="M548,251 L 370,251 Q 355,251 355,266 L 355,274 Q 355,289 370,289 L 371,289 L 386,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M472,251 L 464,251 Q 457,251 457,266 L 457,274 Q 457,289 464,289 L 472,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,327 39,331 39,322" style="fill:rgb(0,0,0)"/>
<path d="M24,198 L 24,312 Q 24,327 34,327 L 45,327"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M66,342A15 15 0 0 0 81 327A15 15 0 0 0 66 311A15 15 0 0 0 50 327A15 15 0 0 0 66 342Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="66" y="327" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="104,327 92,331 92,322" style="fill:rgb(0,0,0)"/>
<path d="M81,327L98,327"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M104,342L208,342L208,311L104,311Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="156" y="327" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-stmt</text>
<polygon points="231,327 219,331 219,322" style="fill:rgb(0,0,0)"/>
<path d="M208,327L225,327"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M246,342A15 15 0 0 0 261 327A15 15 0 0 0 246 311A15 15 0 0 0 231 327A15 15 0 0 0 246 342Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="246" y="327" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="392,289 380,293 380,284" style="fill:rgb(0,0,0)"/>
<path d="M261,327 L 269,327 Q 276,327 276,312 L 276,304 Q 276,289 291,289 L 371,289 L 386,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="660,327 648,331 648,322" style="fill:rgb(0,0,0)"/>
<path d="M261,327L654,327"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M660,327 L 667,327 Q 675,327 675,319 L 675,312"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M424,327 L 432,327 Q 439,327 439,312 L 439,304 Q 439,289 447,289 L 454,289"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="50,364 39,369 39,360" style="fill:rgb(0,0,0)"/>
<path d="M24,311 L 24,349 Q 24,364 34,364 L 45,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M65,379A15 15 0 0 0 81 364A15 15 0 0 0 65 349A15 15 0 0 0 50 364A15 15 0 0 0 65 379Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="65" y="364" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="135,364 123,369 123,360" style="fill:rgb(0,0,0)"/>
<path d="M81,364L129,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M135,379L296,379L296,349L135,349Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="215" y="364" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-or-subquery</text>
<polygon points="350,364 338,369 338,360" style="fill:rgb(0,0,0)"/>
<path d="M296,364L344,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M365,379A15 15 0 0 0 380 364A15 15 0 0 0 365 349A15 15 0 0 0 350 364A15 15 0 0 0 365 379Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="365" y="364" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="660,364 648,369 648,360" style="fill:rgb(0,0,0)"/>
<path d="M380,364L654,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="711,36 699,41 699,32" style="fill:rgb(0,0,0)"/>
<path d="M660,364 L 667,364 Q 675,364 675,349 L 675,51 Q 675,36 690,36 L 690,36 L 705,36"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<circle cx="715" cy="36" r="3.6"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M215,417A15 15 0 0 0 230 402A15 15 0 0 0 215 387A15 15 0 0 0 200 402A15 15 0 0 0 215 417Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="215" y="402" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
<polygon points="230,402 242,398 242,406" style="fill:rgb(0,0,0)"/>
<path d="M296,364 L 303,364 Q 311,364 311,379 L 311,387 Q 311,402 296,402 L 251,402 L 236,402"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M200,402 L 123,402 Q 108,402 108,387 L 108,379 Q 108,364 116,364 L 123,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="122,440 111,444 111,436" style="fill:rgb(0,0,0)"/>
<path d="M81,364 L 88,364 Q 96,364 96,379 L 96,425 Q 96,440 106,440 L 116,440"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M122,455L224,455L224,425L122,425Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="173" y="440" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">join-clause</text>
<path d="M224,440 L 308,440 Q 323,440 323,425 L 323,379 Q 323,364 331,364 L 338,364"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
</svg>
</div><br>

Used by:&nbsp;&nbsp; <a href='./join-clause.html'>join-clause</a>&nbsp;&nbsp; <a href='./select-core.html'>select-core</a>&nbsp;&nbsp; <a href='./select-stmt.html'>select-stmt</a>&nbsp;&nbsp; <a href='./update-stmt.html'>update-stmt</a>&nbsp;&nbsp; <a href='./update-stmt-limited.html'>update-stmt-limited</a><br></br>
References:&nbsp;&nbsp; <a href='./expr.html'>expr</a>&nbsp;&nbsp; <a href='./join-clause.html'>join-clause</a>&nbsp;&nbsp; <a href='./select-stmt.html'>select-stmt</a><br></br>
See also:&nbsp;&nbsp; <a href='../lang_aggfunc.html'>lang_aggfunc.html</a>&nbsp;&nbsp; <a href='../lang_altertable.html'>lang_altertable.html</a>&nbsp;&nbsp; <a href='../lang_attach.html'>lang_attach.html</a>&nbsp;&nbsp; <a href='../lang_createindex.html'>lang_createindex.html</a>&nbsp;&nbsp; <a href='../lang_createtable.html'>lang_createtable.html</a>&nbsp;&nbsp; <a href='../lang_createtrigger.html'>lang_createtrigger.html</a>&nbsp;&nbsp; <a href='../lang_createview.html'>lang_createview.html</a>&nbsp;&nbsp; <a href='../lang_delete.html'>lang_delete.html</a>&nbsp;&nbsp; <a href='../lang_expr.html'>lang_expr.html</a>&nbsp;&nbsp; <a href='../lang_insert.html'>lang_insert.html</a>&nbsp;&nbsp; <a href='../lang_returning.html'>lang_returning.html</a>&nbsp;&nbsp; <a href='../lang_select.html'>lang_select.html</a>&nbsp;&nbsp; <a href='../lang_update.html'>lang_update.html</a>&nbsp;&nbsp; <a href='../lang_upsert.html'>lang_upsert.html</a>&nbsp;&nbsp; <a href='../lang_with.html'>lang_with.html</a>&nbsp;&nbsp; <a href='../partialindex.html'>partialindex.html</a>
</div>