Select Distinct P.PatientCode, P.LastName, P.FirstName, P.Matrix, P.DOB,
P.DiagCode1,

P.DiagCode2,P.DiagCode3, P.DiagCode4, P.DoctorCode,
R.ProgramCode,P.FacilityCode,
P.DiagCode5,P.DiagCode6, P.DiagCode7, P.DiagCode8,
P.Employed,P.RetiredDate,

R.DateFrom, R.DateTo, R.TerminateDate, R.Status, '''' as GroupCreationID
From MdPt0001 P LEFT OUTER JOIN MdPhPtPg R
ON ( P.PatientCode = R.PatientCode )

AND ( ( (R.DateFrom <= '4/4/2017' ) or (R.DateFrom <= '18/08/2019')  ) And
(R.DateTo >= '4/4/2017' ) And
( ( R.Status in ( 'A', 'T' ) )  OR (( R.TerminateDate  >= '4/4/2017' )
AND ( R.Status <> 'A' ) ) ) )


Where  (P.PATIENTCODE in ( Select Distinct Q.PatientCode From MdPhAt01 Q
Where
( Q.ServiceDate >= '4/4/2017' )

AND ( Q.Attendance= 'Y' ) AND ( Q.ServiceDate <= '18/08/2019' ) AND (
Q.Billed = 'N') OR (Q.Billed is null)))



AND  Q.CourseCode in (' + TherapyQuoteString + ')
order by P.LastName, P.FacilityCode