Skip to content

7_join.sql #7 Line 40 #7

@Kellertsn

Description

@Kellertsn

movieid should be 132689

or another method:

SELECT actor.name
FROM actor
JOIN casting ON casting.actorid = actor.id
WHERE casting.movieid = (
SELECT id FROM movie
WHERE title = 'Casablanca' AND yr = 1942
)

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions