Hi All,



I have a query (with a deliberate Cart-Prod)...

SELECT

test_seq.nextval AS id ,o.id AS id_domain ,u.username AS
username

FROM o, u

WHERE u.username NOT IN ( SELECT DISTINCT username FROM p )

;



This produces E_US18AF Next value/current value sequence operators used
in incorrect context.



If I remove the distinct clause the query works OK. If I recode it to
use a left outer join the code works OK.



I've seen this on II 9.2.0 (a64.lnx/143)NPTL + p13767.



Martin Bowes