From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

FULL OUTER JOIN

FULL OUTER JOIN - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

FULL OUTER JOIN

“

- [Instructor] In addition to using right join and left join in your sequel querries. Which, by the way, are also known as right outer joins or left outer join, it's the same thing. We can also choose to execute a full outer join. A full outer join basically returns all records where there is a match in either the left or the right table So in our case, any matching records between employees and departments. It's a combination of a right join and a left join at the same time. In oracle, you can execute a full outer join by specifying the full join syntax as part of the front clause of your sequel command. So lets see full outer joins in action. We can use the same example from our previous exercise, simply changing right join to full join. So our query now reads select and the column names we want to return from employees full join departments on employees.department_id = departments.departnment_id. Lets execute this query, which is again essentially a combination of a right join and…

Contents