title: Iterate Data Table ontop of another Data table and make one table
body: <p>I have a question. 
  Here is the story, I have Student mark sheet (Table <strong>A</strong>)</p>
  
  <pre><code>Name    Course  Marks
  Student 01  32472   44
  Student 02  32472   80
  Student 03  32472   67
  Student 04  32472   76
  Student 05  32472   56
  Student 06  32472   98
  Student 07  32472   13
  Student 08  32472   68
  Student 09  32472   84
  Student 10  32472   93
  </code></pre>
  
  <p>And  I have sheet (Table <strong>B</strong> ) for cut off marks for medals.</p>
  
  <pre><code>Medel     Course    CutOff
  Silver    32472      0-69
  Gold      32472      70 -84
  Platinum  32472      85 -100
  </code></pre>
  
  <p>Could you please help me to get following sheet (Table) in SQL.</p>
  
  <pre><code>Name    Course  Medal
  Student 01  32472   Silver
  Student 02  32472   Gold
  Student 03  32472   Silver
  Student 04  32472   Gold
  Student 05  32472   Silver
  Student 06  32472   Platinum
  Student 07  32472   Silver
  Student 08  32472   Silver
  Student 09  32472   Gold
  Student 10  32472   Platinum
  </code></pre>
  
  <p>How Can I join Table A (Student marks sheet) and Table B (Medal cut off marks sheet) then get Final Table ?</p>
  
  <p>Really appreciate your answers/comments.</p>
  
  <p>Thank you
  Gayan</p>