title: join on three tables? Error in phpMyAdmin
body: <p>I'm trying to use a join on three tables query I found in another post (post #5 <a href="https://stackoverflow.com/questions/3226912/join-three-tables">here</a>). When I try to use this in the SQL tab of one of my tables in phpMyAdmin, it gives me an error: </p>
  
  <pre><code>#1066 - Not unique table/alias: 'm'
  </code></pre>
  
  <p>The exact query I'm trying to use is:</p>
  
  <pre><code>select r.*,m.SkuAbbr, v.VoucherNbr from arrc_RedeemActivity r, arrc_Merchant m, arrc_Voucher v
  LEFT OUTER JOIN arrc_Merchant m ON (r.MerchantID = m.MerchantID)
  LEFT OUTER JOIN arrc_Voucher v ON (r.VoucherID = v.VoucherID)
  </code></pre>
  
  <p>I'm not entirely certain it will do what I need it to do or that I'm using the right kind of join (my grasp of SQL is pretty limited at this point), but I was hoping to at least see what it produced. </p>
  
  <p>(What I'm trying to do, if anyone cares to assist, is get all columns from arrc_RedeemActivity, plus SkuAbbr from arrc_Merchant where the merchant IDs match in those two tables, plus VoucherNbr from arrc_Voucher where VoucherIDs match in those two tables.)</p>
  
  <p><strong>Edited to add table samples</strong></p>
  
  <pre><code>Table arrc_RedeemActivity
  RedeemID | VoucherID | MerchantID | RedeemAmt
  ----------------------------------------------
  1        | 2         |  3         | 25
  2        | 6         |  5         | 50
  
  Table arrc_Merchant
  MerchantID | SkuAbbr
  ---------------------
  3         | abc         
  5         | def         
  
  Table arrc_Voucher
  VoucherID | VoucherNbr
  -----------------------
  2         | 12345       
  6         | 23456
  </code></pre>
  
  <p>So ideally, what I'd like to get back would be:</p>
  
  <pre><code>RedeemID | VoucherID | MerchantID | RedeemAmt | SkuAbbr | VoucherNbr
  -----------------------------------------------------------------------
  1        | 2         | 3          | 25        | abc     | 12345
  2        | 2         | 5          | 50        | def     | 23456
  </code></pre>