On 8/27/24 11:13 AM, Jean-Christophe BOGGIO wrote:
> Le 27/08/2024 à 19:51, Torsten Förtsch a écrit :
>> I guess this query comes back non-empty:
>>
>> SELECT * FROM paliers JOIN tmp_limitcontrats USING(idcontrat) WHERE
>> qtep1 >= qtep2
>
> Yes, it is empty if I keep tmp_limitcontrats to idcontrat=1003
>
> Otherwise, you are right, there are irregular data but not that I'm
> concerned with in that particular case.
>
?:
SELECT numrange( qtep1+1 , qtep2, '[]') AS rangep FROM paliers JOIN
tmp_limitcontrats USING(idcontrat) where qtep1+1 < qtep2
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com