Case 4 the SQL Query Language Provides a Collection of Special

Multiple Choice

Case 4 The SQL query language provides a collection of special command words called SQL keywords. With these keywords, SQL can be used to specify the action that should be carried out in the database. Working with the WebMusic company database, which command is selected for using the data from two tables as in: SELECT FROM CompactDisks ____ Tracks ON CompactDisks.ItemNumber = Tracks.ItemNumber?

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