I don't see anything wrong with this query. What error do you get?

>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")

You can also rewrite it as follow (it may be faster)

SELECT taitem.ident;
       FROM taitem;
       WHERE code IN (SELECT arcode.code FROM arcode ;
	                  WHERE arcode.activity = "EA")

>VFP7 ask me about EXISTS ?
>
>Help!
>
>Thanks
>Eric