SELECT p.Patient_ID, p.Last_Name_M0040, p.First_Name_M0040, p.Admission_Status,p.status,y.PayName
FROM #Request.prefix_db_agency#.patient p
LEFT OUTER JOIN #Request.prefix_db_agency#.Payer y on y.Payer_ID = p.Payer_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.PatientContact pc on pc.Patient_ID = p.Patient_ID
WHERE status <> 'deleted'
AND p.Patient_ID not in (SELECT Patient_ID FROM #Request.prefix_db_agency#.PatientContact
WHERE ContactStatus <> 2 AND Emergency_Contact = 1)
GROUP BY p.Patient_ID
SELECT p.Patient_ID, p.Last_Name_M0040, p.First_Name_M0040, p.Admission_Status,p.status,y.PayName
FROM #Request.prefix_db_agency#.patient p
LEFT OUTER JOIN #Request.prefix_db_agency#.Payer y on y.Payer_ID = p.Payer_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.PatientContact pc on pc.Patient_ID = p.Patient_ID
WHERE status <> 'deleted'
AND p.Employee_ID = '#session.EmployeeID#'
AND p.Patient_ID not in (SELECT Patient_ID FROM #Request.prefix_db_agency#.PatientContact
WHERE ContactStatus <> 2 AND Emergency_Contact = 1)
GROUP BY p.Patient_ID