title: How to do self join
body: <p>I want to do self-join I have written a code as well but its throwing an error and it seems that there is some issue with an alias. </p>
  
  <p>Apart from this it would also be helpful for me if someone let me know any best site where I can learn query in MS Access. I searched a number of places everywhere, it is showing through UI Interface but I want to learn query in MS Access.</p>
  
  <pre><code>(SELECT distinct  itemname,vendorname,price,count(*)
  from vendor_Details1
  group by itemname,vendorname,price
  order by vendorname) A
  inner join
  (SELECT distinct  itemname,vendorname,price,count(*)
  from vendor_Details1
  group by itemname,vendorname,price
  order by vendorname) B
  on A.vendorname=B.vendorname
  </code></pre>