Hey everyone,
I am trying to execute the following code:
Select p.prempl, p.txqtr ;
from a_prehtx pre, a_prehtx p ;
where pre.txqtr = '2' And p.txqtr = '3' ;
AND (p.qtax = 0 AND p.qbase = 0 AND p.qwage = 0) ;
AND pre.prempl = p.prempl ;
AND p.ybase<>(pre.Ybase+NVL(p.qbase,0));
AND pre.taxid = p.taxid ;
group by p.prempl, p.txqtr into cursor curNeedUpdate2


The problem is that for certain prempl's, there are no txqtr = 2. Is there a way in FoxPro to ignore the pre.txqtr = '2' statement if there is not a txqtr = 2 for the prempl? I tried looking up an exists command but could not find one. Any help would be appreciated. Thanks.