duplicate rows returned in a query

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I am using Access 97 (don't ask)
I have linked to several tables in an Oracle 8 dB
the query produces rows of data associated with a Case # (this is a
Cusomer Support dB)
in some cases, not all, there are several rows displayed, all
duplicates relating to the same Case
The only difference in these duplicate rows is that there are more
than one Contacst relating to the Customer Site. But the query is for
one specific Contact.
does anyone have any thoughts on why this is happening and how to
prevent it?
Thanks
Ray
 
Pretty much impossible for anyone to comment without seeing the SQL of your
query, and knowing more about your tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate rows returned 6
Combine Duplicates in Query 0
How to Delete duplicate row access 2003 0
Append Query Issue 0
Duplicate Query 7
Query and Duplicate Rows 2
Duplicates in union query 3
Help with Query 2

Back
Top