I have two Custom Post Types: Movies
and Directors
A Director owns many Movies.
A Director can be either an In-House or Freelance employee.
I'm using Advanced Custom Fields to make a radio group on the Director Post Type where you can set it to either In-House or Freelance.
I'm also using ACF to make a select box in the Movies Post Type where you select a Director and you get the Post Object in return.
How do I make a query so I only get Movies where the Director is an In-House employee?
Edit: I'll provide an example using plain SQL:
SELECT movies.name, directors.name
FROM movies JOIN directors ON directors.id = movies.director_id
WHERE directors.type LIKE '%In-House%'
Is there a better way of querying like this in Wordpress other than doing raw SQL?