Which of the following SQL statements correctly performs an INNER JOIN between tables Orders and Customers using two join conditions?

easy📝 Syntax Q3 of 15

SQL - INNER JOIN

Which of the following SQL statements correctly performs an INNER JOIN between tables Orders and Customers using two join conditions?

ASELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID, Customers.Status = 'Active';

BSELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Status = 'Active';

CSELECT * FROM Orders INNER JOIN Customers WHERE Orders.CustomerID = Customers.ID AND Customers.Status = 'Active';

DSELECT * FROM Orders JOIN Customers ON Orders.CustomerID = Customers.ID OR Customers.Status = 'Active';

Step-by-Step Solution

Solution:

Step 1: Review INNER JOIN syntax
The ON clause specifies join conditions combined with AND for multiple conditions.
Step 2: Analyze options
SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Status = 'Active'; correctly uses AND inside ON; others misuse commas, WHERE, or OR.
Final Answer:
SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID AND Customers.Status = 'Active'; -> Option B
Quick Check:
Multiple conditions must be combined with AND in ON clause [OK]

Quick Trick: Use AND in ON clause for multiple join conditions [OK]

Common Mistakes:

MISTAKES

Master "INNER JOIN" 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