>>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. :)
--sb--