[Solved] Given tables Orders and Customers with columns CustomerID, what will be the result of this query?SELECT Orders.OrderID, Customers.Name FROM Orders JOIN Customers ON Orders.CustomerID = Customers.... | SQL

SQL - INNER JOIN

Given tables Orders and Customers with columns CustomerID, what will be the result of this query?

SELECT Orders.OrderID, Customers.Name FROM Orders JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

Assuming Orders has 3 rows with CustomerIDs 1, 2, 4 and Customers has 2 rows with CustomerIDs 1, 2.

A3 rows with OrderIDs 1, 2, 4 and matching customer names for IDs 1 and 2 only

B2 rows with OrderIDs 1 and 2 only, matching customer names

CAll 3 rows with customer names, including NULL for CustomerID 4

DNo rows because CustomerID 4 does not exist in Customers

Step-by-Step Solution

Solution:

Step 1: Understand INNER JOIN behavior
INNER JOIN returns only rows where the join condition matches in both tables.
Step 2: Apply to given data
Orders have CustomerIDs 1, 2, 4; Customers have 1, 2. Only CustomerIDs 1 and 2 match, so only those rows appear.
Final Answer:
2 rows with OrderIDs 1 and 2 only, matching customer names -> Option B
Quick Check:
INNER JOIN returns only matching rows [OK]

Quick Trick: INNER JOIN shows only matching rows from both tables [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given tables Orders and Customers with columns CustomerID, what will be the result of this query?