ah yes, good old mysql, no subqueries before version 4.1
on actors.id = mov_act.actorid
on mov_act.movieid = movies.id
and movies.name = 'ben hur'
having count(movies.name) = 0
on mvs_actors.id = mvs_mov_act.act_id
on mvs_mov_act.mov_id = mvs_movies.id
and mvs_movies.id = 1
having count(mvs_movies.id) = 0
i now have all actors that aren't in movie with id=1
stupid question, but how do i get the once that are in that movie with id=1??