Multiple inner joins on the same table

[CrmNewbie]

Hi,

I've a problem, in order to retrieve data from multiple tables, I'm joining
(inner join)
the same table with 3 other tables. and therefore i get duplicate records.
How do I get rid of this duplicate rows.



tia,
CrmNewbie

 

[Allen Browne]

Typically you use an inner join to join one table to another, where there is
a one-to-many relation.

Where one record in Table1 has four records in Table2, you get the same
information from Table1 repeated 4 times: once for each record from Table2.
That's how it works. I'm not clear as to what else you expect it to do.

If you want the record from Table1 to appear once only, what you you expect
from Table2? You may be able to use a Totals query to GROUP BY the record in
Table1, and aggregate (e.g. count or sum) the values from Table2. Would that
do?