duplicate entries during query

  • Thread starter Thread starter Budge Tungate
  • Start date Start date
B

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
 
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.
 
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.
 
Back
Top