SELECT Patient_ID, Pt_First, Pt_Last, Pt_Middle FROM #Request.prefix_db_agency#.pPatients WHERE status = 0 AND Patient_ID IN ( SELECT Patient_ID FROM #Request.prefix_db_agency#.pSchedules WHERE Status = 0 AND Progress_Note = 0 GROUP BY Patient_ID ) ORDER BY Pt_Last, Pt_First
Print Date Range Schedule
to
Date Format: mm/dd/yyyy