Which command joins the related Customers and Orders tables based on the common CustomerID field?
A)WHERE CustomerID.Customers = CustomerID.Orders
B)JOIN Customers.CustomerID = Orders.CustomerID
C)WHERE Customers.CustomerID = Orders.CustomerID
D)SELECT Customers.CustomerID AND Orders.CustomerID

Question

Quizplus · Accepted Answer

The WHERE clause is used to specify the condition for joining tables, and in this case, it correctly uses the common CustomerID field to join the Customers and Orders tables.

Which Command Joins the Related Customers and Orders Tables Based