📖
Theory
Understand the concept step by step
FULL JOIN returns rows from both tables.
Matching rows are combined, while unmatched rows from either side are still included with NULL values for the missing side.
Support for FULL JOIN varies by database system.
💻
Example
See how the concept works in SQL
SQL
SELECT users.name, orders.amount
FROM users
FULL JOIN orders
ON users.id = orders.user_id;📤
Output
Understand what the query produces
Matching and unmatched rows from both tables are included.
📝
Practice
Test your understanding
Use a FULL JOIN to compare two related datasets.
❓
MCQs
Check your SQL knowledge
What is the main concept covered in FULL JOIN?
A.Matched and unmatched rows from both tables
B.Only matched rows
C.Only left rows
D.Only right rows
💼
Interview Questions
Prepare for SQL interviews
1
Interview Question
What does FULL JOIN return?
2
Interview Question
How is FULL JOIN different from INNER JOIN?
3
Interview Question
Do all database systems support FULL JOIN?