SELECT *, meds_pathway_lookup.Notes AS medspath_Notes FROM #Request.prefix_db_lookup#.meds_pathway_lookup LEFT OUTER JOIN #Request.prefix_db_lookup#.Meds_New ON Meds_New.Trade_Num = meds_pathway_lookup.Trade_Num LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = meds_pathway_lookup.Patient_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = meds_pathway_lookup.Agency_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = meds_pathway_lookup.Emp_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Coding_Class_PDGM ON CW_Coding_Class_PDGM.Pathway_ID = meds_pathway_lookup.Path_ID WHERE meds_pathway_lookup.Emp_ID IS NOT NULL AND (meds_pathway_lookup.Approved = "Not paired" OR meds_pathway_lookup.Approved = "For Review") AND pPatients.status < 2 AND meds_pathway_lookup.Agency_ID = '#url.agency_id#' AND meds_pathway_lookup.Med_ID != 0 Group by meds_pathway_lookup.ID ORDER BY meds_pathway_lookup.Generic_Name SELECT pProblem.* FROM #Request.prefix_db_agency#.pProblem JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pProblem.Assmt_ID WHERE pAssessments.status = 0 AND pProblem.status = 0 AND pProblem.M0_No like 'M102%' AND pAssessments.Patient_ID = '#Patient_ID#' GROUP BY pProblem.Problem_ID SELECT DISTINCT Description FROM getallproblems WHERE Path_ID = #Path_ID# SELECT DISTINCT Description FROM getallproblems WHERE Problem_ID = #Recomm_problem_ID# #cfcatch.Detail#