SELECT PatientMeds.PatientMeds_ID,PatientMeds.Drug_Name,Meds_New.Classification,PatientMeds.Dose,PatientMeds.Dose_Units,
PatientMeds.Route,PatientMeds.Freq,PatientMeds.Notes,PatientMeds.DateOrdered,PatientMeds.DateDCed,PatientMeds.NewChanged,
PatientMeds.Delete,PatientMeds.Med_Status FROM #Request.prefix_db_agency#.PatientMeds
Left join #Request.prefix_db_lookup#.Meds_New on PatientMeds.Medication_ID=Meds_New.Trade_ID
where Patient_ID='#session.cs.patientid#' order by PatientMeds.Drug_Name ASC
