SELECT DISTINCT pPatients.Patient_ID, pPatients.Status, pPatients.Pt_Last, pPatients.Pt_First, pPatients.Pt_Middle,pPatients.Comments AS Comment, pPatients.Pt_Street,pPatients.Pt_City, pPatients.Pt_State,pPatients.Pt_Zip,pPatients.Pt_Phone, pPtContacts.Patient_ID, pPtContacts.Last_Name, pPtContacts.First_Name, pPtContacts.Pt_Realtionship, pPtContacts.Telephone1, pPtContacts.Emergency AS PrimaryContact,pa.Emerg_Priority AS Priority,pPayer.Pay_Name,pPtPayer.Payer_ID, pPhysicians.Phys_First,pPhysicians.Phys_Last,pPhysicians.Phys_Phone FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pPtContacts ON pPatients.Patient_ID = pPtContacts.Patient_ID AND pPtContacts.status = 0 JOIN #Request.prefix_db_agency#.pAdmit pa ON pPatients.Patient_ID = pa.Patient_ID AND pa.status = 0 JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = pa.Render_Phys_ID AND pPhysicians.status = 0 JOIN #Request.prefix_db_agency#.pPtPayer ON pPatients.Patient_ID = pPtPayer.Patient_ID AND pPtPayer.status = 0 JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID AND pPtPayer.status = 0 WHERE pPatients.Loc_ID = #session.AgencyID# AND pPatients.Status < 2 AND pPatients.Status = '0' AND pPatients.Status = '1' Order by pPtContacts.Emergency ASC,Pt_Last ASC