What is the difference between `FULL OUTER JOIN` and `CROSS JOIN`?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is the difference between `FULL OUTER JOIN` and `CROSS JOIN`?

Key points

  • FULL OUTER JOIN includes NULLs for non-matching rows
  • CROSS JOIN creates a Cartesian product with no conditions
  • FULL OUTER JOIN requires a join condition
  • CROSS JOIN does not involve a WHERE clause

Ready to go further?

Start full exam Practice more questions

Related questions