Hi Nuno,

>Just a little improvement ...
>
>SELECT S.Clm_Id, S.Svc_Dt, P.Active_Ind ;
> FROM Mc_MdSvc S Inner Join Mc_MdClm C on C.Clm_Id = S.Clm_Id
> LEFT JOIN Mc_PlnHs P ON P.Mem_Num = C.Mem_Num ;
> AND P.Pln_Id = C.Pln_Id ;
> AND P.Ins_Id_Num = C.Ins_Id_Num ;
> WHERE C.Adjt_Stat = "Z" ;
> AND P.Active_Ind = .T. ;
> AND Between(S.Svc_Dt, P.Eff_From, P.Eff_Thru) ;
> HAVING ISNULL(P.Active_Ind)
>
>Nuno Brito
>
>Note: I didn´t tested, but i think it work.

Thanks. This seems like it should, but I couldn't make it work. I even moved the on clause after the Ins_Id_Num test. I posted my solution to Ed Rauh if you're interested.