I have 3 tables, 'film', 'actor' and 'cast'. I want to get a list of actors that are in a certain film, but I am brand new to SQL and cannot figure out how to join the tables.
I am comfortable with the SELECT and WHERE, just not the FROM.
You need to join the tables like this
select a.name from actor a join cast c on a.id = c.actorid join film f on f.id = c.filmid where f.title = 'your movie title'