title: Ms access Query error with join
body: <p>I have a problem with ms access query.
  I select 2 tables in query: table1 have 2 items and table2 have 3 items and  both are join with billno but when i build the query in query this become <a href="http://i.stack.imgur.com/UOy6K.png" rel="nofollow">like this</a>:</p>
  
  <pre><code>SELECT
    productionpurchase.PurchNo,
    productionpurchase.Medicine AS PpurchMedi,
    productionpurchase.Qty AS PPurchqty,
    productionpurchase.Price AS PpurchTP,
    productionpurchase.Srate AS PpurchRP,
    productionpurchase.Desc AS PpurchDesc,
    production.desc,
    production2.ExtraQty,
    production.*
  FROM (productionpurchase
    INNER JOIN production ON productionpurchase.PurchNo = production.BillNo)
    INNER JOIN production2 ON productionpurchase.PurchNo = production2.BillNo;
  </code></pre>