>SELECT ; > " " AS CheckOff, a.grpid, a.grpnum, b.lastname, b.firstname, b.dob, a.Hist, a.PlanKey, a.Status, a. Renewal, ; > a.ptd ; > FROM grpextcv a ; > JOIN grpextin b ON a.grpid+a.grpnum=b.grpid+b.grpnum ; > WHERE a.Hist="99" AND ; > SUBSTR(DTOC(a.ptd), 7, 4) >= "1997" AND SUBSTR(DTOC(a.ptd), 7, 4) <= "2009" AND INLIST(a.Status, "A, B") ; > ORDER BY a.grpid, a.grpnum ; > INTO CURSOR tmpActiveBefore2009 > >SELECT ; > " " AS CheckOff, a.grpid, a.grpnum, b.lastname, b.firstname, b.dob, a.Hist, a.PlanKey, a.Status, a. Renewal, ; > a.ptd ; > FROM grpextcv a ; > JOIN grpextin b ON a.grpid+a.grpnum=b.grpid+b.grpnum ; > WHERE a.Hist="99" AND ; > BETWEEN(YEAR(a.ptd), 1997, 2009) AND INLIST(a.Status, "A, B") ; > ORDER BY a.grpid, a.grpnum ; > INTO CURSOR tmpActiveBefore2009 >Try:
SELECT ; " " AS CheckOff, a.grpid, a.grpnum, b.lastname, b.firstname, b.dob, a.Hist, a.PlanKey, a.Status, a. Renewal, ; a.ptd ; FROM grpextcv a, grpextin b ; WHERE a.grpid+a.grpnum=b.grpid+b.grpnum ; AND a.Hist="99" AND ; BETWEEN(YEAR(a.ptd), 1997, 2009) AND INLIST(a.Status, "A, B") ; ORDER BY a.grpid, a.grpnum ; INTO CURSOR tmpActiveBefore2009