[Solved] Consider these tables:Products(ProductID PK, Name)Sales(ProductID FK, Quantity)Why does this query cause an error?SELECT * FROM Products JOIN Sales ON Products.ID = Sales.ProductID; | SQL

SQL - INNER JOIN

Consider these tables:
Products(ProductID PK, Name)
Sales(ProductID FK, Quantity)
Why does this query cause an error?

SELECT * FROM Products JOIN Sales ON Products.ID = Sales.ProductID;

AColumn Products.ID does not exist, causing an error

BForeign key cannot be used in JOIN condition

CJOIN syntax is incorrect, missing JOIN type

DSales table must be listed first in FROM clause

Step-by-Step Solution

Solution:

Step 1: Check column names in JOIN condition
The Products table has ProductID as primary key, not ID.
Step 2: Identify cause of error
Using Products.ID causes an error because that column does not exist.
Final Answer:
Column Products.ID does not exist, causing an error -> Option A
Quick Check:
Wrong column name in JOIN = error [OK]

Quick Trick: Verify column names exactly before joining [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider these tables: