Let's explore **FULL OUTER JOIN**: it does joining for a **union** of records of table1 and table2:

All uncompleted fields got the value **NULL**.

If you're an expert in creating queries for a single table, improve your knowledge! Let's start accessing and manipulating two and more tables. During the course, you'll learn how to work with special statements, what is the join and how to use it, and also will practice a lot!

We shall take a look at the database we'll work with and how we can create a query inside another query.

Learn how to join and work with multiple tables.

Try creating queries with no limits on how you should do that. Use all your knowledge from previous chapters!

Data Manipulation using SQL

SQL Full Outer Join

Solution

SQL Full Outer Join

Solution