>Need an "And" adding in there : Between x and y
>

OK; next time, please just fix it!


>>SWAG, try:
>>
>>

>SELECT S.Clm_Id, S.Svc_Dt ;
>>	FROM Mc_MdSvc S, Mc_MdClm C ;
>>	WHERE C.Adjt_Stat = "Z" ;
>>	AND C.Clm_Id = S.Clm_Id ;
>>	AND NOT EXISTS (SELECT * FROM Mc_PlnHs P ;
>>				WHERE P.Mem_Num = C.Mem_Num ;
>>				AND <b>P.Active_Ind</b> ;
>>				AND P.Pln_Id = C.Pln_Id ;
>>				AND P.Ins_Id_Num = C.Ins_Id_Num ;
>>				AND <b>S.Svc_Date BETWEEN P.Eff_From <i>AND</i> P.Eff_Thru</b> )
>>