SELECT ; ct.Name, cv.GrpID, cv.GrpNum, cv.Date, ; cv.Seq, aa.EMP_ID, cv.CovCd AS PlanKey, ; SPACE(8) AS BnftName, cv.PREM, cv.Bill_Date, ; IIF (NOT EMPTY(aa.Depos_Date), cv.Prem, 0000000.00)) AS Collected ; FROM BLCEXTAA aa ; JOIN BLCEXTCV cv ; ON aa.GrpID+aa.GrpNum+aa.Date+aa.Seq=cv.GrpID+cv.GrpNum+cv.Date+cv.Seq ; JOIN GRPEXTCT ct ; ON cv.GrpID=ct.GrpID ; WHERE ; aa.Stat_Code="P" AND ; cv.GrpID=lcGrpID AND ; cv.CovCd=lcPlanKey AND ; YEAR(cv.bill_date)=2010 ; ORDER BY cv.GrpID, cv.GrpNum, cv.CovCd ; INTO TABLE tmpData