Why outer joins are needed in SQL - Quick Recap

Recall & Review

beginner

What is an outer join in SQL?

An outer join returns all rows from one table and the matching rows from another table. If there is no match, it still shows the row with NULLs for the other table's columns.

beginner

Why do we need outer joins instead of just inner joins?

Because inner joins only show rows with matches in both tables. Outer joins let us see rows even if there is no match, helping us find missing or unmatched data.

intermediate

What are the types of outer joins?

There are three types: LEFT OUTER JOIN (all rows from left table), RIGHT OUTER JOIN (all rows from right table), and FULL OUTER JOIN (all rows from both tables).

beginner

Give a real-life example where an outer join is useful.

Imagine a list of customers and their orders. Some customers may not have placed orders yet. A LEFT OUTER JOIN shows all customers, including those without orders, so we don't miss anyone.

beginner

What happens to unmatched rows in an outer join?

Unmatched rows appear with NULL values in the columns of the table that has no matching row.

Which join returns all rows from the left table and matching rows from the right table?

A LEFT OUTER JOIN

B INNER JOIN

C RIGHT OUTER JOIN

D CROSS JOIN

LEFT OUTER JOIN returns all rows from the left table and matching rows from the right table, filling NULLs where no match exists.

What does an INNER JOIN do?

A Returns all rows from both tables

B Returns only matching rows from both tables

C Returns all rows from the left table

D Returns all rows from the right table

INNER JOIN returns only rows where there is a match in both tables.

Why might you use a FULL OUTER JOIN?

A To get only matching rows

B To get only rows from the left table

C To get only rows from the right table

D To get all rows from both tables, including unmatched ones

FULL OUTER JOIN returns all rows from both tables, showing NULLs where there is no match.

If you want to find customers without orders, which join helps?

A INNER JOIN

B RIGHT OUTER JOIN

C LEFT OUTER JOIN

D CROSS JOIN

LEFT OUTER JOIN shows all customers including those without orders by keeping unmatched rows from the left table.

What value appears in columns of unmatched rows in an outer join?

A NULL

B Empty string

C Default value

D 0

Unmatched rows have NULL values in columns of the table without a matching row.

Explain why outer joins are important when working with related tables in a database.

Think about when you want to see all data even if some parts don't match.

Describe the difference between LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN.

Focus on which table's rows are fully included.