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

#Medication.Classification#

id="Orderdate_#i#" class="form-control" value="#DateFormat(Medication.DateOrdered,"dd-mm-yyyy")#">
Date Format: mm/dd/yyyy
id="Discontinueddate_#i#" class="form-control" value="#DateFormat(Medication.DateDCed,"dd-mm-yyyy")#">
Date Format: mm/dd/yyyy
Update Cancel