contestada

Given the data model, what would a CROSS JOIN
joining the genre table and the instrument table represent?

genre table:
genre_id
name
genre_instrument table:
genre_instrument_id
genre id
instrument_id
instrument table:
instrument id
name

Respuesta :

Every combination of each genre with each instrument, even those that are not represented in the genre_instrument table

Explanation:

The CROSS JOIN clause creates a combination of every row from two or more different tables. Determining the number of results in a result set for a CROSS JOIN is as simple as the product of the number of records in each table. 

Otras preguntas