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

>
>>>VFP7 ask me about EXISTS ?
>>>
>>>Help!
>>>
>>>Thanks
>>>Eric
>ARGH! There is nothing wrong with this. Like 99% of the time, the problem was me! Time to switch career and go sell hotdogs! Sorry for disturbing!

No problem. :)