On fly:
Code:
SELECT MovieList.MovieID, m.MovieName, m.MovieYear, MovieList.MoviesCnt
FROM
(
SELECT ma.MovieID, COUNT(ma.MovieID) As MoviesCnt
FROM (tblMoviesActorsJunction ma INNER JOIN tblActors a1 ON a1.ActorID = ma.ActorID) INNER JOIN tblActors a2 ON a2.ActorID = ma.ActorID
WHERE a1.ActorID = [FirstActorID] and a2.ActorID = [SecondActorID]
GROUP BY ma.MovieID
) MovieList INNER JOIN tblMovies m ON m.MovieID = MovieList.MovieID
This probably lists all movies those 2 actors participated in, without their names.