WebMusic’s Database Designer, Janet, Has Hired an Intern

Multiple Choice

WebMusic’s database designer, Janet, has hired an intern. She has requested that this intern create some SQL queries that would be useful to managers tracking the day-to-day operations of the store.
-The intern needs to complete the following query so that it draws data from two different tables.Which command should she use to complete the query?
SELECT FROM Albums ____ Tracks ON Albums.Cat# = Tracks.Cat#

A) AND
B) INSERT
C) JOIN
D) UPDATE