SELECT pPatients.Patient_ID, pPatients.Pt_First, pPatients.Pt_Last, pPatients.Pt_Middle FROM #Request.prefix_db_agency#.pPatients LEFT OUTER JOIN #Request.prefix_db_agency#.pAuths ON pPatients.Patient_ID = pAuths.Patient_ID AND pAuths.Status = 0 WHERE pPatients.Status = GROUP BY pPatients.Patient_ID ORDER BY Pt_Last
Add Visit on #url.setdate#
#dateformat(now(),"mm/dd/yyyy")##url.setdate#" />