Rename the director table as d within the query.
director
d
Make sure to type director AS d.
director AS d