I have two tables with 15 fields, of which 3 are Last Name, First Name, and ID.
I join Last Name from Table A, to Last Name form Table B, and the same for First Name. I also then Group By to get single row values.
When I join just on names, I get an output row count of 1900 (ID is not in the query).
When I join on the two fields, Last Name, First Name - but this time have ID in the output but not joined, I get an output row count of 2100.
What i am trying to understand is why does the count go up when ID is included in Design View, but is not being joined between Tables A and B.