> 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 a.GrpID="ACS" AND ; > (YEAR(a.ptd) > 1997 AND YEAR(a.ptd) < 2009) AND (INLIST(a.Status, "C, U, T") OR ; > INLIST(a.Renewal, "X, C, L, D")) AND a.GrpID =; > (SELECT grpID FROM grpextin d WHERE INLIST(Status, "A", "B") AND Hist="99" AND ; > d.GrpNum <> a.GrpNum) ; > ORDER BY a.grpid, a.grpnum ; > INTO CURSOR tmpBefore2009_ACS_Only > >Maybe I'm reading it wrong but do you want
(INLIST(a.Status, "C", "U", "T") OR INLIST(a.Renewal, "X", "C", "L", "D"))which could also be written as
(a.status IN ("C", "U", "T") OR a.Renewal IN("X", "C", "L", "D"))