Which of the following is the correct way to write a CROSS JOIN between tables orders and customers in PostgreSQL?

easy📝 Syntax Q3 of 15

PostgreSQL - Joins in PostgreSQL

Which of the following is the correct way to write a CROSS JOIN between tables orders and customers in PostgreSQL?

ASELECT * FROM orders CROSS JOIN customers ON orders.id = customers.id;

BSELECT * FROM orders JOIN customers ON orders.id = customers.id;

CSELECT * FROM orders INNER JOIN customers;

DSELECT * FROM orders CROSS JOIN customers;

Step-by-Step Solution

Solution:

Step 1: Recall CROSS JOIN syntax
The correct syntax is: SELECT * FROM table1 CROSS JOIN table2;
Step 2: Analyze options
SELECT * FROM orders CROSS JOIN customers; matches the correct syntax. SELECT * FROM orders JOIN customers ON orders.id = customers.id; uses JOIN with ON, which is INNER JOIN syntax. SELECT * FROM orders INNER JOIN customers; is incomplete (INNER JOIN requires ON). SELECT * FROM orders CROSS JOIN customers ON orders.id = customers.id; incorrectly adds ON clause to CROSS JOIN.
Final Answer:
SELECT * FROM orders CROSS JOIN customers; -> Option D
Quick Check:
Only option without ON clause and with CROSS JOIN keyword [OK]

Quick Trick: CROSS JOIN syntax has no ON clause [OK]

Common Mistakes:

Master "Joins in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free