JOINING in SQL
Before explaining FULL JOINING in SQL let's first understand what is SQL JOINING and how it works. Okay, actually in SQL, JOINING is used to join and create a set of rows in a temporary table by combining rows from two or more tables.
EXPLORE THE FULL TUTORIAL OF JOINING
- JOINS in SQL
- LEFT JOIN in SQL
- RIGHT JOIN in SQL
FULL JOINING in SQL
In SQL, the FULL JOIN is used to combine the rows from both LEFT_Table and RIGHT_Table, as well as, it also fills the NULL values for the missing matches from the Tables. You can also use the WHERE condition if it is required.
FULL JOINING QUERY LOOKS LIKE
SELECT column_name(s)
FROM LEFT_Table
FULL JOIN RIGHT_Table
ON LEFT_Table .column_name = RIGHT_Table.column_name
WHERE condition;
FULL OUTER JOINING QUERY LOOKS LIKE
SELECT column_name(s)
FROM LEFT_Table
FULL OUTER JOIN RIGHT_Table
ON LEFT_Table .column_name = RIGHT_Table.column_name
WHERE condition;