title: MySQL INTERSECT replacement INNER JOIN - Please explain
body: <p>I have been messing around with this for a while and cannot seem to figure out how to convert the following code from INTERSECT form (unsupported by MySQL) to INNER JOIN form. </p>
  
  <p>If someone could convert the following code to INNER JOIN I think I could understand from the example. Thanks in advance! </p>
  
  <pre><code>(SELECT Student.SSN, First_Name, Last_Name 
  FROM Student, Enrolls 
  WHERE Enrolls.SSN = Student.SSN AND CourseNo='CSC132')
  
  INTERSECT
  
  (SELECT Student.SSN, First_Name, Last_Name 
  FROM Student, Enrolls 
  WHERE Enrolls.SSN = Student.SSN AND CourseNo='CSC134');
  </code></pre>