CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 21

8. (TCO 7) Any type of subquery can be used in the
_________ clause of a SELECT statement. (Points : 4)
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