search for: movies_studio

...s end The underlying database structure is as follows: studios id: integer movies id: integer studio_id: integer actors id: integer actors_studios actor_id: integer studio_id: integer actors_movies actor_id: integer movie_id: integer (Note that in this case I am not using a movies_studios table) The question I want to answer is, given an actor_id and studio_id, how do I find all related movies? Or, stated differently, how do I find all movies for a given studio/actor combination? I have come up with several possible alternatives, but none of them really satisfy-- or, at least...