0 votes
in Sql by
What is Full Join in SQL?

1 Answer

0 votes
by

The Full Join results from a combination of both left and right join that contains all the records from both tables. It fetches rows when there are matching rows in any one of the tables. This means it returns all the rows from the left-hand side table and all the rows from the right-hand side tables. If a match is not found, it puts NULL value. It is also known as FULL OUTER JOIN.

The following visual representation explains it more clearly:

SQL Interview Questions and Answers

The following syntax illustrates the FULL JOIN:

SELECT * FROM table1     

FULL OUTER JOIN table2    

ON join_condition;  

Related questions

0 votes
0 votes
0 votes
asked Jul 8, 2020 in Sql by Robindeniel
+2 votes
asked Jan 14, 2022 in Sql by GeorgeBell
...