• I'll second everyone else's comments: fascinating stuff, Paul. As I was saying, my "problem" is resolved, but I was really interested to understand why SQL was behaving that way. So, thank you, very much. You make it very clear. 🙂

    I will be particularly interested to play around with using NOT EXISTS logic where we currently use WHERE IS NOT NULL.