I´m using FB2.0 I´ve a select like this:



select *

from cabpedido

where

codigo not in (select Codpedido from linalbar)



this select dosen´t return any value because se second select retrn´s null
values



if I change the select by this



select *

from cabpedido

where

codigo not in (select Codpedido from linalbar where CodPedido is not null)



work´s fine. In FB 1.5 the first format work´s fine



thanks



[Non-text portions of this message have been removed]