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