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

Question

Quizplus · Accepted Answer

The keyword "JOIN" is used to combine rows from two or more tables based on a related column between them. In this specific query, we want to select data from both the "CompactDiscs" table and the "Tracks" table, where the rows are related by the "ItemNumber" column. Therefore, the correct command to use is "JOIN".

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