join_table:
table_reference[INNER | CROSS] JOIN
table_factor[
join_condition]
table_referenceSTRAIGHT_JOIN
table_factor
table_referenceSTRAIGHT_JOIN
table_factorON
condition
table_referenceLEFT [OUTER] JOIN
table_reference
join_condition
table_referenceNATURAL [LEFT [OUTER]] JOIN
table_factor
table_referenceRIGHT [OUTER] JOIN
table_reference
join_condition
table_referenceNATURAL [RIGHT [OUTER]] JOIN
table_factor
select_expr, ...
table_references
where_condition]
col_name|
expr|
position}
where_condition]
col_name|
expr|
position}
offset,]
row_count|
row_countOFFSET
offset}]
procedure_name(
argument_list)]
file_name'
export_options
file_name'
var_name[,
var_name]]
table_referencesindicates the
JOINSyntax”.
table_references:
table_reference[,
table_reference] ...
table_reference:
table_factor
join_table
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionLEFT JOINet
STRAIGHT JOINaidera