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