Why does query with linked tables return duplicated data?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A query with two joined tables (include all of one table and only those
matching from other table) is returning duplicated data.
 
CMTH said:
A query with two joined tables (include all of one table and only
those matching from other table) is returning duplicated data.
Click to expand...

Your "only those matching table" has duplicates in the field(s) you are joining
on.
 
The table I am including all records from has 27 records. The table I am
joining to has only 15 records. The query is returning a total of 135 rows.
I am using a date range for my criteria, so the same date can be seen
multiple times in the matching table as well as the all records table.
 
CMTH said:
The table I am including all records from has 27 records. The table
I am joining to has only 15 records. The query is returning a total
of 135 rows. I am using a date range for my criteria, so the same
date can be seen multiple times in the matching table as well as the
all records table.
Click to expand...

Those numbers are irrelevent. When you have a query where you display all
records from TableA and matching records from TableB then any duplicates in
TableB will cause you to get duplicates in your output. That will mean an
output with more rows than TableA has.

When I say duplicates in TableB I mean only on the field or fields you are using
in your join. Any other fields could be different.
 
Back
Top