Choose a join type to get all items from director and only the matching ones from movie.
director
movie
Make sure to type LEFT JOIN.
LEFT JOIN