This tutorial explains how you can use NATURAL JOINs and what a natural join is actually. Included are syntax details and example statements.
Generally speaking, the keyword NATURAL can be treated as a join condition which is added implicitly. If used, it replaces the keywords ON and USING altogether. In MySQL writing natural joins means adding the keyword NATURAL to either an INNER JOIN or an OUTER JOIN. Let’s …[Read more...]