 <p>On the link that you gave the joins are explained very good. So the problem is that you have several records from table A (no matter that there are no duplicates) is that to 1 record in A there are 2 records in B (in some cases). To avoid this you can use either <code>DISTINCT</code> clause, either <code>GROUP BY</code> clause.</p>