Select Query with Joins returning duplicates

[johnctholen]

Hi everyone,

I am building a select query which is grabbing data from multiple tables with items being linked by a unique field "Certificate_ID".

• I have created joins between table A and Table B, and Table A and Table C, linking both by Certificate_ID
• All have the join property set to select all Records from table A, but only those from Table B and Table C where the joined fields are equal.

Table A has 5000 records. Am I correct to assume that my query should only return a max of 5000 records as well? When I select Certificate_ID from A and another column from B it only gives me the 5000 unique records. When I add in a column from Table C it is however returning something like 7500 records, with several being duplicates with the same data in every column.

I have no idea why it is choosing to duplicate records and give me more than I want. I am sure I am overlooking something simple. Can someone please help me figure this out? I am sorry if it is something silly I am doing.

Thanks for the read.
John

 

[pbaldy]

Presumably the key field is duplicated in table C, so you'll get a record for each. You can probably use a totals query to avoid that, but it would be read only.