I bet the records are not perfect duplicates. Don't they differ in at least one field?
- If perfect duplicates, could the duplicates already exist in your table B?
- Obviously check you actually do join with key fields, which in QV (stating the obvious) should have identical field names (no typos, UpPer/Lower case differences etc)
- If table B (qvd) holds multiple values per key field joining, it will naturally create more rows in table A than originally.
Hope above helps. If not, please state info about your two tables