INNER JOINS

[benton msimango via AccessMonster.com]

Hi, I got a problem here when i run this query based on the two tables i get
multiple results per Broker ,EffMonth and SUMofTOTAL instead of one.what
could be wrong???
here's a SQL STATEMENT BELOW.

SELECT [2005].Broker, [2005].EffMonth, [2005].SumOfTOTAL
FROM 2005 INNER JOIN health_prod2 ON [2005].Broker = health_prod2.Broker;

Broker EffMonth SumOfTOTAL
1000012946 01/07/2004 6984
1000012946 01/07/2004 6984
1000012946 01/07/2004 6984
1000012946 01/09/2004 7164
1000012946 01/09/2004 7164
1000012946 01/09/2004 7164

 

[Guest]

Try using the distinct, to eliminate the duplicates.

SELECT distinct [2005].Broker, [2005].EffMonth, [2005].SumOfTOTAL
FROM 2005 INNER JOIN health_prod2 ON [2005].Broker = health_prod2.Broker;