Hi Nuno,
>Sorry ...
>
>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)
>
>i think the clause
> "P.Active_Ind = .T. " with "HAVING ISNULL(P.Active_Ind)"
>
>makes return a empty cursor
>
>Nuno Brito
Using the HAVING clause does return an empty cursor. However, without it ALL claims are returned. Not just the ones without eligibility.
Bill Armbrecht
VFP MCP