I understand you, don’t get me wrong.
But with a full outer join you definitely get them all, and would immediately see, if there is a gap (for whatever reason, holiday in one country not a holiday in another country, etc.)
I agree with you. But this was the question.
In other words:
There shall be counted in Count nothing but the datum itself, not the whole record.
What I want to do: Find in my queries pairs of datum.
And skip what has not a pair of datum.
So there is always a pair otherwise the record should be discarded.
If the use-case is different then the question was wrong.
Yeah... Split topics are the worst
