title: alternative way to DISTINCT
body: <p>i have sql statement like this </p>
  
  <pre><code>SELECT DISTINCT results_sp_08.material_number FROM results_sp_08
          INNER JOIN courses ON results_sp_08.material_number = courses.material_number
          INNER JOIN users ON results_sp_08.id = users.id
          AND results_sp_08.doctor = 'xx260'
  </code></pre>
  
  <p>i need alternative way to DISTINCT in to use it in MySQL version: 4.1.22 ? </p>
  
  <p>is there another way or trick?</p>