title: Join three tables with MAX function
body: <p>I have three tables: <code>student</code>, <code>subject</code> and <code>score</code>.<br>
  I want to display the details of <code>max(subject_id)</code> of each student.</p>
  
  <p><strong>student table</strong></p>
  
  <pre><code>student_id   student_name  exam_date
     1            Sharukh     24/06/12
     2            Amir        23/06/12
  </code></pre>
  
  <p><strong>subject table</strong></p>
  
  <pre><code>subject_id    sub_name
     200         Maths
     300         English
     400         Science
  </code></pre>
  
  <p><strong>score table</strong></p>
  
  <pre><code>student_id   subject_id     score
      1           200         50 
      1           300         20
      2           300         10
  </code></pre>
  
  <p>The result should be:</p>
  
  <pre><code>student_id    student_name     subject_id      score
       1          Sharukh           300            20
       2          Amir              300            10
  </code></pre>