QuestionQ46

VerifiedOperations and Processes

A movie production company wants to identify the actors appearing in its top movies by using the data in the tables below. The resulting data set must include every movie in Table 1, enriched with actor information listed in Table 2.

Question Image

Which query operation produces the required data set?

Explanation

A LEFT JOIN preserves every row from Table 1 and appends matching actor data from Table 2 where Table1.Movie = Table2.Acted_In. Movies with no matching actor remain in the result with null actor fields.

Community Discussion

No comments yet. Be the first to start the discussion!