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
b SELECT zip orde... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12127a90_716469.pdf
180 KBs PDF File
1803_60b8c12127a90_716469.docx
120 KBs Word File
