Recent

Author Topic: [solved] beginner's question: IBX - "fetch all"  (Read 1884 times)

rvk

  • Hero Member
  • *****
  • Posts: 6910
Re: [solved] beginner's question: IBX - "fetch all"
« Reply #15 on: March 08, 2024, 08:52:11 pm »
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  >:D

 

TinyPortal © 2005-2018