What does a FULL OUTER JOIN return?

SQL Fundamentals Easy

SQL Fundamentals — Easy

What does a FULL OUTER JOIN return?

Key points

  • FULL OUTER JOIN includes all rows from both tables
  • NULLs are used for unmatched rows
  • Combines results of LEFT JOIN and RIGHT JOIN

Ready to go further?

Related questions