Hi,



I need your help on this...
I have the following tables:

roles: actor id, movie id, roles (each actor can play in different movies)
movie-generes: movie id, generes (each movie can be related to several generes)

I want to create a query that will show me the following details:

1. id of actors who haven't played in a movie of the genere 'comedy' but played in movies of the genere 'romance'
2. each id should be shown once
3. one of my problems is that a movie is associated with many generes so you can't just ignore the row with the genere 'comedy'.
you need to take down all the rows of the same movie.

Does anyone know how to do it?
I would preffer not doing it with code.