Only one instance per record

[Spica]

I have this query:

SELECT TapeNr, Title, StartTime, EndTime
FROM Movies
INNER JOIN Actors
ON Movies.ID = Actors.MovieID
WHERE Actors.Actor = "Carol"

The problem is that when there are more than one actor in a movie that has the name "Carol", the same movie exists more than once in the result.

Is there any way that I can do this so a movie only can exist once in the result?

 

[aleb]

SELECT distinct TapeNr, Title, StartTime, EndTime
FROM Movies
INNER JOIN Actors
ON Movies.ID = Actors.MovieID
WHERE Actors.Actor = "Carol"


That might help