|
|
MySQL accepts any of the following join syntaxes:
table_name, table_name table_name [CROSS] JOIN table_name table_name INNER JOIN table_name condition table_name STRAIGHT_JOIN table_name table_name LEFT [OUTER] JOIN table_name condition table_name LEFT [OUTER] JOIN table_name table_name NATURAL [LEFT [OUTER]] JOIN table_name table_name LEFT OUTER JOIN table_name ON conditional_expr table_name RIGHT [OUTER] JOIN table_name condition table_name RIGHT [OUTER] JOIN table_name table_name NATURAL [RIGHT [OUTER]] JOIN table_name
The table can simply be a table_name, use an alias (with AS), or specify or ignore indexes (with USE/IGNORE index).
The condition syntax is as follows:
ON conditional_expr | USING (field_names)
The conditional_expr is the same as what can exist in a WHERE clause.
|
|