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 ...
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.
Continued success with the project.
