SELECT phy.Phys_Last,phy.Phys_First,phy.Emp_ID,phy.Phys_Street, phy.Phys_City,phy.Phys_State FROM #Request.prefix_db_agency#.Communication cm JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = cm.Patient_ID AND pAdmit.status = 0 JOIN #Request.prefix_db_lookup#.pPhysicians phy ON phy.Phys_ID = pAdmit.Render_Phys_ID WHERE cm.Comm_ID = '#arguments.Comm_ID#' AND phy.Phys_Fax IS NOT NULL ORDER BY phy.Phys_Last, phy.Phys_First