Which of the following correctly describes a CROSS JOIN?

SQL Fundamentals Medium

SQL Fundamentals — Medium

Which of the following correctly describes a CROSS JOIN?

Key points

  • CROSS JOIN creates a Cartesian product
  • Combines every row from both tables
  • Useful for generating all possible combinations
  • Not limited to matching rows like other join types

Ready to go further?

Related questions