SELECT DISTINCT an.Patient_Id, an.F177, an.F178, an.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = an.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer pp ON pp.Patient_ID = pPatients.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer p ON pp.Payer_ID = p.Pay_ID WHERE an.Status = 0 AND pp.Status = 0 AND p.Status = 0 AND pPatients.Status < 2 AND ( (an.F177 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) OR (an.F178 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) ) AND p.Biller_Type IN ( ) Group By #groupby# SELECT an.Patient_Id, an.F177, an.F178, an.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments an LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = an.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer pp ON pp.Patient_ID = pPatients.Patient_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer p ON pp.Payer_ID = p.Pay_ID WHERE an.Status = 0 AND pp.Status = 0 AND p.Status = 0 AND pPatients.Status < 2 AND ( (an.F177 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) OR (an.F178 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)#) ) AND p.Biller_Type IN ( ) Group By #groupby# select * from getNameQuery Order by #orderby#