Materialize/doc/user/layouts/partials/sql-grammar/join-expr.svg

<svg xmlns="http://www.w3.org/2000/svg" width="915" height="409">
   <polygon points="9 17 1 13 1 21"/>
   <polygon points="17 17 9 13 9 21"/>
   <rect x="31" y="3" width="96" height="32"/>
   <rect x="29" y="1" width="96" height="32" class="nonterminal"/>
   <text class="nonterminal" x="39" y="21">select_pred</text>
   <rect x="65" y="69" width="68" height="32" rx="10"/>
   <rect x="63"
         y="67"
         width="68"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="73" y="87">CROSS</text>
   <rect x="65" y="113" width="88" height="32" rx="10"/>
   <rect x="63"
         y="111"
         width="88"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="73" y="131">NATURAL</text>
   <rect x="193" y="145" width="78" height="32"/>
   <rect x="191" y="143" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="201" y="163">join_type</text>
   <rect x="331" y="69" width="52" height="32" rx="10"/>
   <rect x="329"
         y="67"
         width="52"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="339" y="87">JOIN</text>
   <rect x="403" y="69" width="78" height="32"/>
   <rect x="401" y="67" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="411" y="87">table_ref</text>
   <rect x="45" y="233" width="78" height="32"/>
   <rect x="43" y="231" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="53" y="251">join_type</text>
   <rect x="143" y="233" width="52" height="32" rx="10"/>
   <rect x="141"
         y="231"
         width="52"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="151" y="251">JOIN</text>
   <rect x="215" y="233" width="78" height="32"/>
   <rect x="213" y="231" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="223" y="251">table_ref</text>
   <rect x="333" y="233" width="64" height="32" rx="10"/>
   <rect x="331"
         y="231"
         width="64"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="341" y="251">USING</text>
   <rect x="417" y="233" width="26" height="32" rx="10"/>
   <rect x="415"
         y="231"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="425" y="251">(</text>
   <rect x="483" y="233" width="64" height="32"/>
   <rect x="481" y="231" width="64" height="32" class="nonterminal"/>
   <text class="nonterminal" x="491" y="251">col_ref</text>
   <rect x="483" y="189" width="24" height="32" rx="10"/>
   <rect x="481"
         y="187"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="491" y="207">,</text>
   <rect x="607" y="265" width="40" height="32" rx="10"/>
   <rect x="605"
         y="263"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="615" y="283">AS</text>
   <rect x="667" y="265" width="120" height="32"/>
   <rect x="665" y="263" width="120" height="32" class="nonterminal"/>
   <text class="nonterminal" x="675" y="283">join_using_alias</text>
   <rect x="827" y="233" width="26" height="32" rx="10"/>
   <rect x="825"
         y="231"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="835" y="251">)</text>
   <rect x="333" y="309" width="40" height="32" rx="10"/>
   <rect x="331"
         y="307"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="341" y="327">ON</text>
   <rect x="393" y="309" width="92" height="32"/>
   <rect x="391" y="307" width="92" height="32" class="nonterminal"/>
   <text class="nonterminal" x="401" y="327">expression</text>
   <rect x="793" y="375" width="94" height="32"/>
   <rect x="791" y="373" width="94" height="32" class="nonterminal"/>
   <text class="nonterminal" x="801" y="393">select_post</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m96 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-146 66 l2 0 m2 0 l2 0 m2 0 l2 0 m42 0 h10 m68 0 h10 m0 0 h158 m-266 0 h20 m246 0 h20 m-286 0 q10 0 10 10 m266 0 q0 -10 10 -10 m-276 10 v24 m266 0 v-24 m-266 24 q0 10 10 10 m246 0 q10 0 10 -10 m-256 10 h10 m88 0 h10 m20 0 h10 m0 0 h88 m-118 0 h20 m98 0 h20 m-138 0 q10 0 10 10 m118 0 q0 -10 10 -10 m-128 10 v12 m118 0 v-12 m-118 12 q0 10 10 10 m98 0 q10 0 10 -10 m-108 10 h10 m78 0 h10 m40 -76 h10 m52 0 h10 m0 0 h10 m78 0 h10 m0 0 h392 m-868 0 h20 m848 0 h20 m-888 0 q10 0 10 10 m868 0 q0 -10 10 -10 m-878 10 v144 m868 0 v-144 m-868 144 q0 10 10 10 m848 0 q10 0 10 -10 m-858 10 h10 m78 0 h10 m0 0 h10 m52 0 h10 m0 0 h10 m78 0 h10 m20 0 h10 m64 0 h10 m0 0 h10 m26 0 h10 m20 0 h10 m64 0 h10 m-104 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m84 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-84 0 h10 m24 0 h10 m0 0 h40 m40 44 h10 m0 0 h190 m-220 0 h20 m200 0 h20 m-240 0 q10 0 10 10 m220 0 q0 -10 10 -10 m-230 10 v12 m220 0 v-12 m-220 12 q0 10 10 10 m200 0 q10 0 10 -10 m-210 10 h10 m40 0 h10 m0 0 h10 m120 0 h10 m20 -32 h10 m26 0 h10 m-560 0 h20 m540 0 h20 m-580 0 q10 0 10 10 m560 0 q0 -10 10 -10 m-570 10 v56 m560 0 v-56 m-560 56 q0 10 10 10 m540 0 q10 0 10 -10 m-550 10 h10 m40 0 h10 m0 0 h10 m92 0 h10 m0 0 h368 m42 -240 l2 0 m2 0 l2 0 m2 0 l2 0 m-144 306 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m94 0 h10 m3 0 h-3"/>
   <polygon points="905 389 913 385 913 393"/>
   <polygon points="905 389 897 385 897 393"/>
</svg>