• Mysql treats INNER and CROSS JOINs identically
• Here's a secret: INNER JOIN and ',' are semantically equivalent in MySQL
• STRAIGHT_JOIN is identical to JOIN, and shouldn't normally be necessary
• NATURAL JOIN: matches on all identically named columns
• 99% of the time, you'll be doing a LEFT [OUTER] JOIN or an [INNER] JOIN

NEXT
PREVIOUS
Master Index