Tag Archives: outer join

MySQL NATURAL JOIN Tutorial & Examples

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 … Continue reading

Posted in Join Tutorials | Tagged , , , , | 4 Comments

MySQL RIGHT OUTER JOIN Tutorial & Examples

Here you find information about writing RIGHT JOINs (also referred to as RIGHT OUTER JOINs). This introduction into right joins includes a detailed description, syntax information and right outer join example statements. The Venn diagram on the left represents a result set … Continue reading

Posted in Join Tutorials | Tagged , , , , | 1 Comment

MySQL LEFT OUTER JOIN Tutorial & Examples

Here you find information about writing LEFT JOINs (also referred to as LEFT OUTER JOINs). This introduction into left joins includes a description, syntax information and example statements that use left outer joins. The Venn diagram on the left represents a result set … Continue reading

Posted in Join Tutorials | Tagged , , , , | 3 Comments

MySQL OUTER JOIN Tutorial & Examples

Here you find information about OUTER JOINs in MySQL statements. This tutorial is a general introduction. Syntax details and example statements are split into a LEFT OUTER JOIN tutorial and RIGHT OUTER JOIN tutorial because these are specific outer joins. 

Posted in Join Tutorials | Tagged , , | 8 Comments