Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
symbol
⟗
alternative syntax
full outer join
<div>optional join condition; if no join condition is given it acts as a natural full outer join
<div>
</div>
</div>
<div>
<h4 id="relalg-operations-leftsemijoin">left semi join</h4>
<table></table></div>
<strong>from_item</strong> [ INNER ] JOIN <strong>from_item</strong> NATURAL
<strong>from_item</strong> [ INNER ] JOIN <strong>from_item</strong> USING ( join_column [, ...] )
<strong>from_item</strong>
<strong>from_item</strong> {'{'} LEFT | RIGHT | FULL } [ OUTER ] JOIN ON join_condition
<strong>from_item</strong>
<strong>from_item</strong> {'{'} LEFT | RIGHT | FULL } [ OUTER ] JOIN NATURAL <strong>from_item</strong>
<strong>from_item</strong> {'{'} LEFT | RIGHT | FULL } [ OUTER ] JOIN USING ( join_column [, ...] ) <strong>from_item</strong>
and <strong>with_query</strong> is:
<strong>with_query_name</strong> AS ( <strong>select</strong> )
<div>
</div>