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
| Answers Explanation & Hints:
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. |