SQL FULL JOIN

SQL FULL JOIN clause is used to select all the matched records from either left or right side table.

SQL FULL JOIN Clause Syntax

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

SQL FULL JOIN Clause Example

Table: Employees

Table: Tickets

Select all the employees and all the tickes:

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

The result will look like:

Note: The employee Axedul doesn’t have a ticket and the ticket 2166 doesn’t have an employee, but they are all listed in the result.