How bout:

>I'm trying to exclude any records with the EMPID = 7260 AND PLANID = 2571. If the EMPID = 7260 and the PLANID = 1234, then I do want the record. The SQL below is removing all records with a PLANID of 2571. I'm trying to do this quickly for a production issue. What should the syntax be?
>
>Renoir
>
>

>
>	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 (NOT (PMEMPDET.EMPID = 7260 AND PMEMPDET.PLANID = 2571)) ;
>		AND Pmempdet.Planid = tmpPlans.Planid ;
>		AND Pmempdet.empid == pmemp.empid ;
>		AND !Pmemp.NoDisplay ;
>		INTO CURSOR Tmp_hold1
>
>