SQL FULL JOIN

In this section, we will help you understand the concept of the SQL FULL Join clause with a few examples.

The SQL FULL Join query is executed to display the integrated results of the left join and right join.

The SQL FULL Join query display all the data, and the NULL value is returned at the missing place of the record.

The syntax of the SQL FULL Join is as follows:

SELECT table1.column_name1, table1.columnname2, table1.column_name3, table1.columnname4, table2.column_name1, table2.column_name2, table2.column_name3, table2.column_name4 FROM table1 FULL JOIN table2;

Let’s understand the SQL FULL Join with the help of examples.

Assume the following table, which has certain data.

Table Name 1- D_Students

Table Name 2- Department

Example 1: Write a query on the D_students and Department table where the second_semester percentage is 78.

SELECT Student_Id, Student_Name, First_Semester, Second_Semester, Third_Semester, Fourth_Semester, Fifth_Semester, Sixth_Semester, Total, Department_Name FROM D_Students FULL JOIN Department WHERE Second_Semester = 78;  

The above SQL FULL Join query joins the D_Students table and department, and displaying the records where the second_semester percentage is 78.

The output of the above example is as follows:

Example 2: Write a query on the D_students and Department table where Student_Name start with the letter ‘A’.

SELECT Student_Id, Student_Name, First_Semester, Second_Semester, Third_Semester, Fourth_Semester, Fifth_Semester, Sixth_Semester, Total, Department_Name FROM Department FULL JOIN D_Students WHERE Student_Name LIKE 'A%';

The above SQL FULL Join query joins the D_Students table and department, and displaying the records where the Student_Name is start with the letter 'A'.

The output of the above example is as follows: