Given the following query: SELECT zip, order# FROM customers NATURAL JOIN orders; Which of the following queries

Question:

Given the following query:

SELECT zip, order#

FROM customers NATURAL JOIN orders;

Which of the following queries is equivalent?

a. SELECT zip, order#

FROM customers JOIN orders

WHERE customers.customer# = orders.customer#;

b. SELECT zip, order#

FROM customers, orders

WHERE customers.customer# = orders.customer#;

c. SELECT zip, order#

FROM customers, orders

WHERE customers.customer# = orders.customer# (+);

d. None of the above

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

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: