Given the following query: SELECT lastname, firstname, order# FROM customers LEFT OUTER JOIN orders USING (customer#) ORDER

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 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

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: