Description: The RIGHT JOIN (or RIGHT OUTER JOIN) keyword Return all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
A right outer join (or right join) closely resembles a left outer join, except with the tables reversed. Every row from the "right" table (B) will appear in the joined table at least once. If no matching row from the "left" table (A) exists, NULL will appear in columns from A for those records that have no match in A.
A right outer join returns all the values from the right table and matched values from the left table (NULL in case of no matching join predicate).
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
SELECT column_name(s)FROM table_name1
RIGHT JOIN table_name2
-- orSELECT*FROM employee RIGHT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID
-- for example:SELECT Person.LastName, Person.FirstName, Sales.OrderNo
RIGHT JOIN Sales
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.