github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/docs/generated/sql/bnf/joined_table.bnf (about)

     1  joined_table ::=
     2  	'(' joined_table ')'
     3  	| table_ref 'CROSS' opt_join_hint 'JOIN' table_ref
     4  	| table_ref ( 'FULL' ( 'OUTER' |  ) | 'LEFT' ( 'OUTER' |  ) | 'RIGHT' ( 'OUTER' |  ) | 'INNER' ) opt_join_hint 'JOIN' table_ref ( 'USING' '(' ( ( name ) ( ( ',' name ) )* ) ')' | 'ON' a_expr )
     5  	| table_ref 'JOIN' table_ref ( 'USING' '(' ( ( name ) ( ( ',' name ) )* ) ')' | 'ON' a_expr )
     6  	| table_ref 'NATURAL' ( 'FULL' ( 'OUTER' |  ) | 'LEFT' ( 'OUTER' |  ) | 'RIGHT' ( 'OUTER' |  ) | 'INNER' ) opt_join_hint 'JOIN' table_ref
     7  	| table_ref 'NATURAL' 'JOIN' table_ref