From the course: SQL Essential Training

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

The RIGHT JOIN

The RIGHT JOIN - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

The RIGHT JOIN

“

- [Instructor] Now before getting into our right outer join, I wanted to remind you about something we mentioned in the beginning of the course with regard to relational database management systems. If you recall, we did mention there are various types of relational database management systems, such as the one we're using for this course, SQL Light. But there are others like Microsoft SQL Server and Oracle. And we mentioned that there is about a 5% difference with regard to the syntax that you would write in one RDBMS versus another. Now, I'm calling this out before getting into the right outer join, because right outer joins are not supported in SQL Light. But since right joins are still very popular in other relational database management systems I think it's appropriate to include it in our discussion here. Now, the right outer join returns the entire right table as well as matching information from the left table. The…

Contents