T-SQL » Operators » RIGHT JOIN
- Syntax:
-
FROM table1 RIGHT JOIN table2
ON table1.field1 compoperator table2.field2 - table1
- The name of the first (left) table from which information is to be retrieved.
- table2
- The name of the second (right) table from which information is to be retrieved.
- field1
- The field from the first table that is being compared to field2 from the second table.
- compoperator
- A comparison operator such as =, >, <, etc.
- field2
- The field from the second table that is being compared to field1 from the first table.
The RIGHT JOIN and the similar LEFT JOIN operators can be used in any FROM clause to combine records from two tables. The RIGHT JOIN operator is used to create a right outer join and includes all of the records from the second (right) of the two tables, even if there are no matching values for records in the first.
Although LEFT JOIN or RIGHT JOIN operators can be nested inside an INNER JOIN, the converse is not true. An INNER JOIN operator cannot be nested inside a LEFT JOIN or RIGHT JOIN.
Examples
Code:
SELECT Employee.Username, Project.ProjectName
FROM Employee RIGHT JOIN Project
ON Employee.EmployeeID = Project.EmployeeID;
Output:
Username ProjectName Jack Smith Hardwork Herman Allen Hardwork Jill Swafford Hardwork Bob Thornton Hardwork Mike Sosebee Grindstone Jill Swafford Grindstone Zack Womble Hardwork NULL Paperwork NULL Dailytasks
(9 row(s) affected)
Explanation:
This example of a RIGHT JOIN returns the names of all projects, whether or not any of the employees were currently working on them, but with employee names where applicable.
The above example is in contrast to the INNER JOIN example which only returns those records in which the data in the joined fields is the same (i.e. only records for employees currently engaged in projects).
Language(s): MS SQL Server
See Also:
