Home›Learn›SQL›FULL JOIN
SQL Master CourseBeginner Friendly

FULL JOIN

Learn how FULL JOIN combines matched and unmatched rows from both tables.

📘 Chapter 31 / 51⏱️ 8–10 Min Read🎯 Beginner Friendly
Course Progress61%

Course Progress

61%

31 / 51 chapters

📖

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?