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 ...
Not without seeing the data. And not without seeing the actual SQL.
What does the term "files" mean in this context, by the way?
What does the term "files" mean in this context, by the way?
My thanks for your comment. I realized that there was a null condition that I hadn't accounted for. All good now. Thanks, again, for taking the time to respond.
PS> by "files", I was referring to the Tables I use. Sorry for the confusion. I was once a mainframe programmer.
- Congratulations on spotting the discrepancy. Nulls are tricky little devils.
Continued success with the project.
