Dear VFP user,
Please can someone help me with the next SQL statement:
SELECT p.perfkcmp, p.perpk, c.cervalid, MAX(c.cerinvalid) AS expiredate ;
FROM person p, certificate c ;
WHERE c.cerfkper = p.perpk ;
GROUP BY p.perpk ;
INTO CURSOR Cr_Temp
The question now:
In cursor...