You are looking around for a specific MySQL join description, example statements or MySQL join know how? In either case, the MySQL Join Tutorials are your friend! We explain every join MySQL supports. Our aim is it to provide information for all kinds of developers. It doesn’t matter if you want to learn from the ground up or need access to details quickly.

Supported Joins

The following joins are completely supported by MySQL and can be used with all available MySQL versions provided by web hosting companies. Simply follow the links to see syntax details, example statements and links to further information about the specific join.

• INNER JOIN / JOIN
• CROSS JOIN
• OUTER JOIN
• LEFT OUTER JOIN / LEFT JOIN
• RIGHT OUTER JOIN / RIGHT JOIN
• STRAIGHT JOIN
• NATURAL JOIN

Further information

We hope you’ve found the information you’re looking for. If you are searching for general information, a tutorial or something like that. take a look at one or more of the following resources:

• halfgaar.net – SQL joins are easy
• SQL join types
• MySQL Performance Blog
• Wikipedia – SQL Joins
• How to simulate FULL OUTER JOIN in MySQL – Xaprb
• MySQL 5.1 Reference Manual
• MySQL Forums