Hi again,

Can you tell why when we use "IN" instead of " = " the sub select
return all the rows and not only, which match to the sub select ???

Exemple :

SELECT

NUMVOL, DATEVOL, NUMAVION, IDPILOTE
from affectation
where IDPILOTE = (select first :n skip (:n * :p - :n) IDPILOTE from
pilote)

It works !!! returns 3 rows.

SELECT

NUMVOL, DATEVOL, NUMAVION, IDPILOTE
from affectation
where IDPILOTE IN (select first :n skip (:n * :p - :n) IDPILOTE from
pilote).

Don't work returns all the rows...

Thanks.