Which JOIN clause would join the two tables Orders and Customers, using the CustomerID field in both tables as the relationship between the two tables?
SELECT *
FROM Orders
LEFT JOIN Customers ON ____________ = ______________;
- ON Customers.CustomerID=Orders.CustomerID
- ON Orders.CustomerID=Customers.CustomerID
- ON Orders.CustomerID=Orders.CustomerID
- ON Customers.CustomerID=Customers.CustomerID
Explanation: The correct JOIN clause would begin with table 1 (the same tables as in the FROM clause) and the CusterID field followed by table 2 and the CustomerID field.
ON Orders.CustomerID=Customers.CustomerID
Related exam: Module 7.5.2 Quiz - Introduction to Structured Queries
