Find all movies with any actor in common
Posted on 2007-07-22
I have an Access 2003 DB in support of a VB6 application. The Access DB has two tables (named movies and ActorsLink) which are joined on the common field 'MovieID'. The ActorsLink table contains every ActorID for all MovieID's in the DB. (i.e. If 15 Actors appear in one movie, each of the 15 has a separate row along with the MovieID in question.)
I'm looking for the correct syntax for a parameter query. If a MovieID is entered, I need the query to return all other MovieID's and Titles which HAVE AT LEAST ONE ACTOR IN COMMON with the MovieID entered.
Does anyone know how to do this?