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

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 CompactDiscs ____ Tracks ON CompactDiscs.ItemNumber = Tracks.ItemNumber

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

Correct Answer:

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Access For Free