Full JOIN in SQL - A Practical Guide with Examples

Process Advisors

*Subject to Terms and Condition

What is FULL JOIN in SQL?

Under SQL joins, FULL JOIN is a keyword, which is used to select all records from the right table and also from the left table


The FULL JOIN basically returns all records from the left table and also from the right table. For example, let’s say, we have two tables, Table A and Table B. When FULL JOIN is applied on these two tables, it returns us all records from both Table A and Table B. If the condition is not met, then the null value is displayed instead.
A Brief Introduction to Full Join


SELECT columns
FROM table1 name
FULL JOIN table2 name
ON table1.coumn_x = table2.column_y;

where SELECT, FULL JOIN, and ON are the keywords, columns are the list of columns, table1 is the first table, table2 is the second table, and column_x and column_y are the columns for performing Left Join, followed by a semicolon.

Become a Database Architect

Enroll yourself in SQL online course and give a head-start to your career in SQL!


Let’s apply FULL JOIN to two tables, the employee table, and the department table

Select employee.e_name, employee.e_dept, department.d_name, department.d_location from employee
FULL JOIN department
ON employee.e_dept = department.d_name;



After writing the query, click on the execute button to check for errors. Once the query is executed, a message appears like ‘Commands completed successfully.
This brings us to the end of this tutorial section on JOIN operators.

Stay up-to-date on the latest SQL Join features!

Course Schedule

Name Date Details
SQL Training 30 Sep 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 07 Oct 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 14 Oct 2023(Sat-Sun) Weekend Batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *