SELECT Pmempdet.Planid, Pmempdet.Policy, Firstname, Midname, Lastname, SSN, ; Employed, Pmempdet.Leligible, Pmempdet.Particip, Email, pmemp.empid, ; PmEmpDet.VestER, PmEmpDet.VestPs ; FROM pmemp, Pmempdet ; WHERE (PMEMPDET.EMPID <> 7260 AND PMEMPDET.PLANID <> 2571) ; AND Pmempdet.Planid = tmpPlans.Planid ; AND Pmempdet.empid == pmemp.empid ; AND !Pmemp.NoDisplay ; INTO CURSOR Tmp_hold1