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

Question

Quizplus · Accepted Answer

The correct command to complete the query is JOIN, which combines data from two different tables based on a matching column or key. In this case, the tables being joined are Albums and Tracks based on the Cat# column. The other options (AND, INSERT, UPDATE) are not appropriate commands for joining tables in SQL.

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