Hi again,

Can you tell me why when we use "IN" instead of " = " in a sub-select
it returns all the rows and not only matching rows ???

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.