Take a look to my answer to Roxanne. Hope I'm right. :)

Vlad

>I think you need to add aliases to that second query and add a condition, like this:
>
>
>SELECT * FROM ALPHA_X A WHERE NOT EXISTS( ;
> SELECT * FROM ALPHA_X B WHERE A.Somefield = B.Somefield AND B.stype="WL " AND B.progtype="NP") ;
> INTO CURSOR ALPHATMP
>
>I think that ought to do it.
>
>How come no new picture of you from DevCon (with hat, of course)?
>
>George