duplicate entries during query

[Budge Tungate]

When I create a query, a number of rows are duplicated.
The data tables do not have the duplicate entries, just
the query. Any ideas why?

--Budge

 

[Danny J. Lesandrini]

Can you paste the SQL? It's a table relationship issue ... or
a cartisian product. You might try using a group by clause,
but it's hard to say w/o seeing the code.

 

[Guest]

It ended up that my original assumption was inaccurate.
I didn't have the right key fields in a data table I was
linking to, thus there were duplicate fields in the
linked table. After correcting this problem (i.e.
putting in key fields), the query ran correctly.