Which SQL clause would join a Customers table with an Orders table assuming that they are related

Question:

Which SQL clause would join a Customers table with an Orders table assuming that they are related in a one-to-many relationship on a field called CustID in both tables?

a. WHERE Customers.CustID = Orders.CustID

b. WHERE Customers = Orders AND CustID = CustID

c. WHERE Customers.CustID & Orders.CustID

d. WHERE IN Customers, Orders (CustID)

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: