Title: Which of the following SQL statements will display the title of the books ordered by customer 1003? ... Post by: Jmini on Jan 31, 2018 Which of the following SQL statements will display the title of the books ordered by customer 1003?
a. SELECT titleFROM customers NATURAL JOIN booksWHERE customer = 1003; b. SELECT titleFROM customers JOIN orders USING (customer)JOIN orderitems USING (order) JOIN books USING (isbn)WHERE customer = 1003; c. SELECT titleFROM customers JOIN orders ON (customer)JOIN orderitems ON (order) JOIN books ON (isbn)WHERE customer = 1003; d. both a and b Title: Which of the following SQL statements will display the title of the books ordered by customer 1003? ... Post by: rcollins105 on Jan 31, 2018 Content hidden
Title: Which of the following SQL statements will display the title of the books ordered by customer 1003? ... Post by: Jmini on Jan 31, 2018 This puts a :) on my face
|