لطفا منتظر باشید ...
JOIN
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.
