What does a CROSS JOIN produce?

SQL Fundamentals Easy

SQL Fundamentals — Easy

What does a CROSS JOIN produce?

Key points

  • CROSS JOIN creates all possible combinations of rows
  • It does not filter based on any conditions
  • The result is a larger dataset than the original tables

Ready to go further?

Related questions