SELECT DISTINCT(an.Patient_Id) FROM #Request.prefix_db_agency#.Assessment_New an , #Request.prefix_db_agency#.ScheduleItems si, #Request.prefix_db_agency#.Payer p WHERE an.Agency_Id = '#session.AgencyId#' AND (an.Start_of_Care_M0030 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) AND si.Assessment_Id = an.Assessment_Id AND p.Payer_Id = si.Payer_Id AND p.PayerType IN ( ) select Distinct(Patient_ID) from getNameQuery