title: SQL inner join creates duplicates
body: <p>I have three tables, Suppliers, Products and Deliveries. I'd like to show the suppliers names and the quantity from the delivery table. There are 5 different suppliers and there are 12 deliveries. I expect that the joined table should contain 12 rows with names and deliveries.</p>
  
  <p>This is my code. </p>
  
  <pre><code>SELECT  Suppliers.SNAME, Deliveries.QTY
  FROM Suppliers, Deliveries
  INNER JOIN  Products
  ON Deliveries.P=Products.Penter (typo, should be Products.P)
  </code></pre>
  
  <p>The output is 60 rows with many duplicates and some incorrect matches.</p>
  
  <p>Tables:
  <img src="https://i.stack.imgur.com/e2lDd.png" alt="Suppliers">
  <img src="https://i.stack.imgur.com/3ZPZR.png" alt="Products">
  <img src="https://i.stack.imgur.com/A0gAS.png" alt="Deliveries"></p>