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?
 
You must log in or register to reply here.

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

Canon IP 6600D Photo Printer 2
Selection of rows with same values only 1
example purchasing database? 0
Inconsistent working of SQL 1
Automatically generate and collect data from a single email in Acc 3
How to refer to a VBA module variable within a report select state 3
query too slow 1
Buying a modern phone help needed. ;-) 14

Back
Top