SQL RIGHT JOIN

SQL RIGHT JOIN clause is very similar with SQL LEFT JOIN clause, it is used to select all the matched records from the right side table, regardless if it has matched records in the left side table or not.

SQL RIGHT JOIN Clause Syntax

SELECT Table1.Column1, Table1.Column2, ... , Table2.Column1, Table2.Column2, ...
FROM Table1
RIGHT JOIN Table2
ON Table1.ColumnName = Table2.ColumnName

SQL RIGHT JOIN Clause Example

Table: Employees

Table: Tickets

Select all the tickets, if they belong to any employees, list the employees:

SELECT Employees.EmployeeId
           , Employees.FirstName
           , Employees.LastName
           , Tickets.TicketNo
FROM Employees
RIGHT JOIN Tickets
ON Employees.EmployeeId = Tickets.EmployeeId

The result will look like:

Note: The ticket 2410 doesn’t have any records matched in the table Employees, but it is still listed in the result with the Employee information null.