JOIN

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.



Mastering MySQL 4
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors: Ian Gilfillan

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net