[Solved] Why does the following PostgreSQL query cause an error?SELECT * FROM products CROSS JOIN sales ON products.id = sales.product_id; | PostgreSQL

PostgreSQL - Joins in PostgreSQL

Why does the following PostgreSQL query cause an error?
SELECT * FROM products CROSS JOIN sales ON products.id = sales.product_id;

ABecause CROSS JOIN does not support an ON clause for filtering.

BBecause the table names are incorrect.

CBecause the ON clause should use WHERE instead.

DBecause CROSS JOIN requires a USING clause instead of ON.

Step-by-Step Solution

Solution:

Step 1: Understand CROSS JOIN limitations
CROSS JOIN produces a Cartesian product and does not accept an ON clause for filtering.
Step 2: Analyze the query
The query incorrectly uses ON with CROSS JOIN, which is invalid syntax in PostgreSQL.
Final Answer:
Because CROSS JOIN does not support an ON clause for filtering. -> Option A
Quick Check:
ON clause is only valid with INNER or LEFT JOIN [OK]

Quick Trick: CROSS JOIN never uses ON clause [OK]

Common Mistakes:

Master "Joins in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does the following PostgreSQL query cause an error?