Here's the scenario:
Table A has 1,000,000 records
Table B has 1,000,001 records
In this scenario, we know that all 1,000,000 records in table A match (by primary key) 1,000,000 records in Table B.
What's the fastest way to identify that 1 extra record in Table B?
So far, I'm using a summary list field in Table A to gather all of the primary keys, then setting a global multikey field in table C, and using GTRR from there to table B. Is there a faster method?