title: MySQL join data from same table twice
body: <p>I have table info with 3 rows: id,monter1,monter2. Monter1 and monter2 are id's from table monterzy (id, name, surname) that i want to join with. The problem is i cant make a proper query to pick up these values then in php. Currently i have:</p>
  
  <pre><code>SELECT i.id
       , m.name
       , m.surname 
    FROM info i
    JOIN monterzy m
      ON i.monter1 = m.id;
  </code></pre>
  
  <p>I want to expand it to also get monter2 and corresponding name and surname. I have searched on google, there were examples with AS but i have no idea how to do it. Thanks!</p>