database - MySQL query on single table to find multiple rows -


i trying figure out way find shared credits 2 people in movie database, example:

table: 'credits'
columns: 'id','movie','person'

my other problem person might have multiple credits same movie, how filter out duplicates? appreciated. following have far. on right track?

select distinct movie credits person = 'condition1' or person = 'condition2' group movie having count(*)=2 

select distinct cr1.movie credits cr1 join credits cr2 using (movie) cr1.person = {person 1 goes here} , cr2.person = {person 2 goes here} 

Comments