I nonjoin-table-expression
join-table-expression
: : = table-reference [NATURAL] JOIN
table-reference [ON conditional-expression
I USING (column-commalist) ]
I table-reference CROSS JOIN table-reference
I ( join-table-expression )
table-reference
: : = table [ [ AS ] range-variable
[ ( column-commalist ) ] ]
I ( table-expression ) [ AS ] range-variable
[ ( column-commalist ) ]
I join-table-expression
nonjoin-table-expression
: : = nonjoin-table-term
I table-expression UNION [ ALL ]
[ CORRESPONDING [ BY ( column-commalist ) ] ]
table-term
I table-expression EXCEPT [ ALL ]
[ CORRESPONDING [ BY ( column-commalist ) ] ]
table-term
nonjoin- table-term
: : = nonjoin- table-primary
I table-term INTERSECT [ ALL ]
[ CORRESPONDING [ BY ( column-commalist ) ] ]
table-primary
table-term
: : = nonjoin-table-term
I join-table-expression
table-primary
; : = nonjoin-table-primary
I join-table-eapression
nonjoin-table-primary
: : = TABLE table
I table-constructor
I select-expression
I ( nonjoin-table-expression )
table-constructor
: : = VALUES row-constructor-commalist
row-constructor
: : = scalar-expression
I ( scalar-expression-commalist )
I ( table-expression )
select-expression
: : = SELECT [ ALL | DISTINCT ] select-item-commalist
Не знайшли потрібну інформацію? Скористайтесь пошуком google:
|
|