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 ?