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

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

Step by Step Solution

3.35 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

b SELECT zip orde... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12127a90_716469.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127a90_716469.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!