Which of the following SQL statements correctly performs a CROSS JOIN between tables Orders and Customers?

easy📝 Syntax Q3 of 15

SQL - Advanced Joins

Which of the following SQL statements correctly performs a CROSS JOIN between tables Orders and Customers?

ASELECT * FROM Orders INNER JOIN Customers;

BSELECT * FROM Orders JOIN Customers ON Orders.id = Customers.id;

CSELECT * FROM Orders CROSS JOIN Customers;

DSELECT * FROM Orders CROSSJOIN Customers;

Step-by-Step Solution

Solution:

Step 1: Recall CROSS JOIN syntax
The correct syntax for CROSS JOIN is: SELECT * FROM Table1 CROSS JOIN Table2;
Step 2: Evaluate options
SELECT * FROM Orders CROSS JOIN Customers; matches the correct syntax. SELECT * FROM Orders JOIN Customers ON Orders.id = Customers.id; is an INNER JOIN with a condition. SELECT * FROM Orders INNER JOIN Customers; is incomplete syntax for INNER JOIN. SELECT * FROM Orders CROSSJOIN Customers; uses an invalid keyword 'CROSSJOIN'.
Final Answer:
SELECT * FROM Orders CROSS JOIN Customers; -> Option C
Quick Check:
Correct CROSS JOIN syntax uses 'CROSS JOIN' keywords [OK]

Quick Trick: Use 'CROSS JOIN' keywords explicitly [OK]

Common Mistakes:

MISTAKES

Master "Advanced Joins" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes