CIS 336 STUDY Career Begins/cis336study.com CIS 336 STUDY Career Begins/cis336study.com | Page 21

WHERE HAVING FROM ORDER BY GROUP Page 3- Multiple Choice

1.( TCO 7) Using the BOOK _ CUSTOMER and BOOK _ ORDER tables shown below for references, which SQL statement will return the same results as the following SQL statement?

SELECT * FROM book _ customer, book _ order;( Points: 4)

SELECT * FROM book _ order CROSS JOIN book _ customer;

SELECT * FROM book _ order, book _ customer

WHERE book _ order. customer # = book _ customer. customer #;

SELECT * FROM book _ order, book _ customer

WHERE book _ order. customer # > book _ customer. customer #;