FULL OUTER JOIN Basics

Problem

You are merging two databases after a company acquisition and need to find unmatched records on both sides. Your mentor suggests a specific join type. Write a query that outputs concept with the value: "A FULL OUTER JOIN returns all rows from both tables, with NULLs in places where the join condition is not met."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution