Which of the following queries is valid? (refer to the tables in the JustLee Books database.) a. SELECT b.title, b.retail, o.quantityFROM books b NATURAL JOIN orders odNATURAL JOIN orderitems oWHERE od.order# ¼ 1005; b. SELECT b.title, b.retail, o.quantityFROM books b, orders od, orderitems oWHERE orders.order# ¼ orderitems.order#AND orderitems.isbn ¼ books.isbnAND od.order# ¼ 1005; c. SELECT b.title, b.retail, o.quantityFROM books b, orderitems oWHERE o.isbn ¼ b.isbnAND o.order# ¼ 1005; d. none of the above
Which of the following queries is valid? (refer to the tables in the JustLee Books database.) a. SELECT b.title, b.retail, o.quantityFROM books b NATURAL JOIN orders odNATURAL JOIN orderitems oWHERE od.order# ¼ 1005; b. SELECT b.title, b.retail, o.quantityFROM books b, orders od, orderitems oWHERE orders.order# ¼ orderitems.order#AND orderitems.isbn ¼ books.isbnAND od.order# ¼ 1005; c. SELECT b.title, b.retail, o.quantityFROM books b, orderitems oWHERE o.isbn ¼ b.isbnAND o.order# ¼ 1005; d. none of the above
Chapter9: Joining Data From Multiple Tables
Section: Chapter Questions
Problem 6MC
Related questions
Question
Which of the following queries is valid? (refer to the tables in the JustLee Books
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr