In this SQL tutorial we're going to learn the concept of OUTER JOIN and the difference between OUTER JOIN and what we’ve learned up until this point - INNER JOIN.
Key concepts to remember -
* The INNER JOIN returns only rows with matching values on both tables
* The LEFT OUTER JOIN returns all rows from the left side table, including those without any match on the right side table
* The RIGHT OUTER JOIN returns all rows from the right side table, including those without any match on the left side table
* The FULL OUTER JOIN as a combination of the RIGHT and LEFT outer joins
Course Examples -
[ Ссылка ]
ACDB Database -
[ Ссылка ]
Written SQL tutorials including exercises -
[ Ссылка ]
About Myself -
[ Ссылка ]
My Linkedin Page -
[ Ссылка ]
My Facebook Page -
[ Ссылка ]
SQL Platform Differences (comparing MySQL & Oracle) -
* Syntax covered in this lesson stays exactly the same on MySQL & Oracle, except : MySQL does not support FULL OUTER JOIN - [ Ссылка ]
![](https://i.ytimg.com/vi/sLEXYrNdzKg/maxresdefault.jpg)