title: complex sql query many to many
body: <p>I've been created my database like that:</p>
  
  <p><img src="https://i.stack.imgur.com/2kgRa.png" alt="My database diagram"></p>
  
  <p>I want to select person and movie names which is same person act as "Oyuncu" and "Senarist"</p>
  
  <p>Please help me. I wrote a query like that;</p>
  
  <pre><code>select 
      MovieName,PersonName,RoleName 
  from 
      Movies,
      MoviesPersonRole,
      PersonRole,
      Person,
      Role
  where 
      Movies.Id = MoviesPersonRole.MovieId 
      and 
      PersonRole.Id = MoviesPersonRole.PersonRoleId 
      and 
      PersonRole.RoleId = Role.Id 
      and 
      PersonRole.PersonId = Person.Id
  </code></pre>
  
  <p>and the results are</p>
  
  <pre><code>MovieName         PersonName    RoleName
  Pulp Fiction       Mehmet        Oyuncu
  Pulp Fiction       Mehmet        Senarist
  Matrix             Aylin         Oyuncu
  LOTR               Gökberk       Oyuncu
  LOTR               Gökberk       Senarist
  Pulp Fiction       Aylin         Oyuncu
  </code></pre>