Question: Given the following query: SELECT lastname, firstname, order# FROM customers LEFT OUTER JOIN orders USING (customer#) ORDER BY customer#; Which of the following queries returns

Given the following query:

SELECT lastname, firstname, order#

FROM customers LEFT OUTER JOIN orders

USING (customer#)

ORDER BY customer#;

Which of the following queries returns the same results?

a. SELECT lastname, firstname, order#

FROM customers c OUTER JOIN orders o

ON c.customer# = o.customer#

ORDER BY c.customer#;

b. SELECT lastname, firstname, order#

FROM orders o RIGHT OUTER JOIN customers c

ON c.customer# = o.customer#

ORDER BY c.customer#

c. SELECT lastname, firstname, order#

FROM customers c, orders o

WHERE c.customer# = o.customer# (+)

ORDER BY c.customer#;

d. None of the above

Step by Step Solution

3.39 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c SELECT lastname firs... 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_60b8c12127b41_716473.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127b41_716473.docx

120 KBs Word File

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