Question: Which of the following queries is valid? a. SELECT b.title, b.retail, o.quantity FROM books b NATURAL JOIN orders od NATURAL JOIN orderitems o WHERE od.order#
Which of the following queries is valid?
a. SELECT b.title, b.retail, o.quantity
FROM books b NATURAL JOIN orders od
NATURAL JOIN orderitems o
WHERE od.order# = 1005;
b. SELECT b.title, b.retail, o.quantity
FROM books b, orders od, orderitems o
WHERE orders.order# = orderitems.order#
AND orderitems.isbn = books.isbn
AND od.order# = 1005;
c. SELECT b.title, b.retail, o.quantity
FROM books b, orderitems o
WHERE o.isbn = b.isbn
AND o.order# = 1005;
d. None of the above
Step by Step Solution
3.50 Rating (163 Votes )
There are 3 Steps involved in it
c SELECT btitle bret... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12127a38_716468.pdf
180 KBs PDF File
1803_60b8c12127a38_716468.docx
120 KBs Word File
