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
Medication
Name
Class
Dose/Units/Unit Type
Route
Frequency
Notes
Ordered/Discontinued Pick a datePick a date
New or Changed checked/>checked/>checked/>
medication list

medication profile