Which of the following SQL statements correctly performs a LEFT JOIN between Orders and Customers on Orders.customer_id = Customers.id?

easy📝 Syntax Q3 of 15

SQL - LEFT and RIGHT JOIN

Which of the following SQL statements correctly performs a LEFT JOIN between Orders and Customers on Orders.customer_id = Customers.id?

ASELECT * FROM Orders LEFT JOIN Customers ON Orders.customer_id = Customers.id;

BSELECT * FROM Customers LEFT JOIN Orders ON Orders.customer_id = Customers.id;

CSELECT * FROM Orders INNER JOIN Customers ON Orders.customer_id = Customers.id;

DSELECT * FROM Customers INNER JOIN Orders ON Orders.customer_id = Customers.id;

Step-by-Step Solution

Solution:

Step 1: Identify left table
The LEFT JOIN preserves all rows from the left table, which is the first table in the FROM clause.
Step 2: Match join condition
The ON clause must correctly relate Orders.customer_id to Customers.id.
Final Answer:
SELECT * FROM Orders LEFT JOIN Customers ON Orders.customer_id = Customers.id; -> Option A
Quick Check:
LEFT JOIN keeps all Orders rows [OK]

Quick Trick: LEFT JOIN keeps all rows from first table in FROM [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