title: Simple query on MySQL Sakila Database
body: <p>I haven't written SQL queries in a few years and am a little rusty. I am trying to write a query that will select all films based on a given actor name.  So given the name 'sandra', I want to select the film that is in the film table that has 'sandra' in the first_name or last_name of the actor table. There is a film_actor table that links the two tables but I cannot figure out how to do it correctly. The closest I have gotten is <code>SELECT * FROM film f INNER JOIN film_actor fa ON fa.actor_id = a.actor_id WHERE a.first_name LIKE '%sandra%';</code> which returns an INNER JOIN table of actors and films. This result also has a film_id field that I think I want to utilize for selecting all the films in the film table.</p>