title: MYSQL Joining operations in the same table
body: <pre><code>SELECT DISTINCT mp.Group_Name FROM measurement_test mt, measurement_point mp, measurement_values mv 
                          WHERE mt.Test_ID = mv.Test_ID AND mv.Point_ID = mp.Point_ID AND mt.ID_Number = 'WR20120603_05' 
  
  
  SELECT DISTINCT mp.Group_Name FROM measurement_test mt, measurement_point mp, measurement_values mv 
                          WHERE mt.Test_ID = mv.Test_ID AND mv.Point_ID = mp.Point_ID AND mt.ID_Number = 'WR20120603_04'
  </code></pre>
  
  <p>Above are the two queries that i am using in my web page. Actually i want to get only the common group_name values of the results between the two queries, Is there any other posssible way to implement this particular scenario, or simplyfying the above two queries?</p>