SELECT * FROM #Request.prefix_db_lookup#.pPhysicians WHERE Emp_ID = '#FORM.Emp_ID#' AND status =0 SELECT Event.Event_ID, Event.EventSub_ID, Event.Patient_ID, Event.Employee_ID, Event.who_observed, Event.MD_notified, Event.injury, Event.Event_Date, Event.Memo, Event.Resolved, Event.Record_Created_By, Event.Followup_Desc, Event.Followup_Memo, pEmployee.Emp_ID, pEmployee.Emp_Last, pEmployee.Emp_First, EventSubjects.EventSub_ID, EventSubjects.Subject, pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pPhysicians.Phys_ID, e1.Emp_Last AS LastName, e1.Emp_First AS FirstName, e1.Emp_Street1, e1.Emp_City, e1.Emp_State, e1.Emp_Zip, e1.Emp_Telephone AS Telephone1, Agency.Agency_ID, Agency.Agency_Name, Agency.Agency_Contact_Phone FROM #Request.prefix_db_agency#.Event JOIN #Request.prefix_db_lookup#.pEmployee ON Event.Employee_ID = pEmployee.Emp_ID JOIN #Request.prefix_db_agency#.pPatients ON Event.Patient_ID = pPatients.Patient_ID AND pPatients.Status IN (0,1,4) JOIN #Request.prefix_db_agency#.EventSubjects ON Event.EventSub_ID = EventSubjects.EventSub_ID JOIN #Request.prefix_db_lookup#.Agency ON Event.Agency_ID = Agency.Agency_ID JOIN #Request.prefix_db_lookup#.pPhysicians ON pPhysicians.Phys_ID = (SELECT Render_Phys_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = pPatients.Patient_ID AND status = 0) LEFT JOIN #Request.prefix_db_lookup#.pEmployee e1 ON pPhysicians.Emp_ID = e1.Emp_ID WHERE Event.Event_ID = #url.ID# AND Event.Agency_ID = #session.AgencyID# ORDER BY Event.Event_Date DESC; SELECT Agency_Name, Agency_Address1, Agency_City, Agency_State, Agency_Zip, Agency_Contact_Phone, Agency_Fax FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = #session.AgencyID# request.myPdf = toBase64( gettingfile ); UPDATE #Request.prefix_db_agency#.Event_to SET Date_Sent = #now()# WHERE Event_ID = '#url.Event_ID#'