What is the correct technical nomenclature for the various bits of a JOIN statement


JOIN
tablename
alias
ON
fieldname
condition
fieldname


Roy Lambert

<<Roy Lambert wrote:

What is the correct technical nomenclature for the various bits of a JOIN statement>>

Is this what you were looking for?

========================================================

<joined table> ::=
<cross join> | <qualified join> | (<joined table>)

<cross join> ::= <table reference> CROSS JOIN <table reference>

<qualified join> ::=
<table reference> [NATURAL] [<join type>] JOIN <table reference> [<join specification>]

<join specification> ::= <join condition> | <named columns join>
<join condition> ::= ON <search condition>
<named columns join> ::= USING «join column list»
<join type> ::= INNER | <outer join type> [OUTER] | UNION
<outer join type> ::= LEFT | RIGHT | FULL
<join column list> ::= <column name list>

<table reference> ::=
<table name> [[AS] <correlation name>[(<derived column list>)]] | <derived table>
[AS] <correlation name> [(<derived column list>)] | <joined table>

<derived table> ::= <table subquery>

<column name list> ::=
<column name> [{ <comma> <column name> }...]

=========================================================================


You can obtain SQL grammars from http://savage.net.au/SQL/index.html.


Richard Harding. . .

Richard


>What is the correct technical nomenclature for the various bits of a JOIN statement>>
>
>Is this what you were looking for?

Thanks but not really, it gives more options than Tim's manual and uses different words but no more detail.

Its not a problem I'll invent my own just that if an accepted nomenclature existed I'd have used it.

Roy Lambert