Getting Duplicate Data

[saw15]

Good day ..

Running a query that uses approx 12 tables to retrieve data. When the query runs, it pulls back the correct data and then duplicates it. Should pull back 3 rows, it does but then it pulls back another 3 with the exact same row id etc.

I believe that this is happening because of one of the joins, but am not sure. Is there anyway to figure out the exact problem?

Thanks

 

[tlbroadbent]

You are probably correct in assuming that one of the joins is producing two matches. You can find the culprit by removing one join at a time until the offending join is found. You can eliminate duplicates by using the keyword DISTINCT after the Select in your query. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.