Title: Which of the following queries will return the same results as the following SQL statement? SELECT ... Post by: kinglazy on Jan 31, 2018 Which of the following queries will return the same results as the following SQL statement? SELECT c.customer, lastname, firstname, order FROM customers c, orders o WHERE c.customer = o.customer;
a. SELECT customer, lastname, firstname, orderFROM customers NATURAL JOIN orders; b. SELECT customer, lastname, firstname, orderFROM customers JOIN orders USING (customer); c. SELECT c.customer, lastname, firstname, orderFROM customers c, orders o; d. both a and b Title: Which of the following queries will return the same results as the following SQL statement? SELECT ... Post by: 19leekichang on Jan 31, 2018 Content hidden
Title: Which of the following queries will return the same results as the following SQL statement? SELECT ... Post by: kinglazy on Jan 31, 2018 Passing because of you
|