Eric,

I prefer to use an INNER JOIN instead of EXISTS you can use multiple conditions in the JOIN clause like this:

SELECT taitem.ident;
       FROM taitem;
       inner join arcode ;
         on arcode.code = taitem.code AND ;
       	    arcode.activity = "EA"

>What is wrong with this :
>SELECT taitem.ident;
> FROM taitem;
> WHERE EXISTS (SELECT arcode.code FROM arcode ;
> WHERE taitem.code = arcode.code AND;
> arcode.activity = "EA")
>
>VFP7 ask me about EXISTS ?