SQL FULL JOIN
FULL JOIN creates the result-set by combining results of both LEFT JOIN and RIGHT JOIN. The result-set will contain all the rows from both tables. For the rows for which there is no matching, the result-set will contain NULL values.
Syntax
The syntax of SQL FULL JOIN is:
SELECT table1.column1,table1.column2,table2.column1,....
FROM table1
FULL JOIN table2
ON table1.matching_column = table2.matching_column;
Here,
- table1: First table.
- table2: Second table
- matching_column: Column common to both the tables.
FULL JOIN Example
Let’s look at the example of FULL JOIN clause, and understand it’s working
SELECT Student.NAME,StudentCourse.COURSE_ID
FROM Student
FULL JOIN StudentCourse
ON StudentCourse.ROLL_NO = Student.ROLL_NO;
Output:
NAME |
COURSE_ID |
---|---|
HARSH |
1 |
PRATIK |
2 |
RIYANKA |
2 |
DEEP |
3 |
SAPTARHI |
1 |
DHANRAJ |
NULL |
ROHIT |
NULL |
NIRAJ |
NULL |
NULL |
4 |
NULL |
5 |
NULL |
4 |
SQL Joins (Inner, Left, Right and Full Join)
SQL Join operation combines data or rows from two or more tables based on a common field between them.
In this article, we will learn about Joins in SQL, covering JOIN types, syntax, and examples.