duplicated data

  • Thread starter Thread starter Elsie
  • Start date Start date
E

Elsie

Hi, when I link 2 tables/queries with the same key, there is a tendency that
the returned data has duplicates.

for example,

item A has a transaction with supplier A at price $100 and,
item A has another transaction with supplier B at price $150.

my query returns:

item A with supplier A at $100
item A with supplier A at $150
item A with supplier B at $100
item A with supplier B at $150

Why is this so? How do I make sure that my query is returning distinct data?

Elsie
 
This is distinct data as there are no duplicate rows.

Can a supplier can have a transaction with multiple items, and an item can
occur in multiple transactions?
 
What does your SQL statement look like, and what are the fields in the two
tables?
 
Back
Top