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
Post a Comment