title: SQL query with join shows only one result
body: <p>I have sql query which should shows all records from table swt_modules, but it shows only first row.</p>
  
  <pre><code>$query1 = mysql_query ("SELECT swt_modules.id, swt_modules.name, swt_exam_regs.name AS exam_regs
                          FROM `swt_modules`
                          JOIN `swt_exam_regs`
                          USING ( `id` )
                          WHERE swt_exam_regs.id = swt_modules.exam_regulation
                          ORDER BY swt_modules.name DESC , swt_modules.id DESC
                          LIMIT " . $limit . "");
  while ($fetch1 = mysql_fetch_array ($query1))
  {
  ...
  }
  </code></pre>
  
  <p>I have in this table (swt_modules) 3 rows and in each of them value of field "exam_regulation" is 1. In table swt_exam_regs I have only 1 row with 2 columns - id and name. Swt_modules.id stores id number. Which join I should use to be able to see all records?</p>
  
  <p><img src="https://i.stack.imgur.com/5lFGf.png" alt="result after join">
  <img src="https://i.stack.imgur.com/rHahL.png" alt="records in swt_modules table"></p>