Which of the following is the correct syntax for a LEFT JOIN between tables Customers and Orders on CustomerID?

easy📝 Syntax Q3 of 15

SQL - LEFT and RIGHT JOIN

ASELECT * FROM Customers LEFT JOIN Orders WHERE Customers.CustomerID = Orders.CustomerID;

BSELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;

CSELECT * FROM Customers JOIN Orders LEFT ON Customers.CustomerID = Orders.CustomerID;

DSELECT * FROM Customers LEFT JOIN Orders USING CustomerID;

Step-by-Step Solution

Solution:

Step 1: Review LEFT JOIN syntax
The correct syntax is: FROM left_table LEFT JOIN right_table ON condition.
Step 2: Check each option
SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID; matches the correct syntax exactly.
Final Answer:
SELECT * FROM Customers LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID; -> Option B
Quick Check:
Correct LEFT JOIN syntax uses ON clause [OK]

Quick Trick: LEFT JOIN syntax: FROM left_table LEFT JOIN right_table ON condition [OK]

Common Mistakes:

MISTAKES

Master "LEFT and RIGHT 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