Forum Discussion
Two exact files - but they don't match
I've written a SELECT DISTINCT query, comparing FileA to FileB, WHERE all fields (7) of both files must match. The ORDER BY is on ID and Dates. I should see a list of all the records from FileA, but ...
I can venture a guess as to the explanation, based on this comment "... all fields (7) of both files must match." It would appear that in those records, that is not the case, one or more of those fields differs between the two tables. It may be worthwhile to identify one candidate of that group of 943 records and study it in detail in both tables.
