SELECT DISTINCT c.Comm_Id, c.CommSub_Id, c.Comm_Date ,cs.CommSub_Id, cs.Subject,c.Memo,c.Followup_Desc, c.Followup_Memo,c.Resolved ,e.Emp_ID, e.Emp_Last, e.Emp_First ,(SELECT Pt_Last FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = c.Patient_Id AND pPatients.Status < 2) AS Last_Name_M0040 ,(SELECT Pt_First FROM #Request.prefix_db_agency#.pPatients WHERE Patient_Id = c.Patient_Id AND pPatients.Status < 2) AS First_Name_M0040 FROM #Request.prefix_db_agency#.Communication c, #Request.prefix_db_lookup#.pEmployee e, #Request.prefix_db_agency#.CommunicationSubjects cs WHERE c.Agency_ID = '#session.AgencyId#' AND e.Emp_ID = c.Employee_Id AND cs.CommSub_Id = c.CommSub_Id AND c.Resolved = 'No' ORDER BY c.Comm_Id DESC

Communication History #session.Display# (#session.AgencyLogin#)
Date	Subject	Memo	FU Action	FU Memo	Assigned to	Patient	Resolved?

#DateFormat(GetComm.Comm_Date,"mm/dd/yyyy")#

#Subject#

#Memo#

#Followup_Desc#

#Followup_Memo#

SELECT ct.Viewed, e.Emp_Last, e.Emp_First FROM #Request.prefix_db_agency#.communication_to ct, #Request.prefix_db_lookup#.pEmployee e WHERE ct.Comm_Id = '#Comm_Id#' AND e.Emp_ID = ct.Employee_Id ORDER BY e.Emp_Last, e.Emp_First #geta.Emp_Last# ,#LEFT(geta.Emp_First,1)# #geta.Emp_Last# ,#LEFT(geta.Emp_First,1)#.#DateFormat(geta.Viewed, "mm/dd")# @ #LCASE(TimeFormat(geta.Viewed, "hh:mm tt"))#

#GetComm.Last_Name_M0040#, #GetComm.First_Name_M0040#

#Resolved#