1
select `rd`.`ReportDeliveryID` AS `ReportDeliveryID`,`rd`.`ReportScheduleID` AS `ReportScheduleID`,`rd`.`ReportScheduleRecipientID` AS `ReportScheduleRecipientID`,`rd`.`LTReportID` AS `LTReportID`,`rep`.`ReportTitle` AS `ReportDeliveryName`,elt(`rd`.`DeliveryMethod`,'Email','File') AS `ReportDeliveryMethod`,`rd`.`DeliveryFileFormat` AS `ReportDeliveryFileFormat`,`rd`.`DeliveryParameter` AS `ReportDeliveryParameters`,`rd`.`DateAdded` AS `ReportDeliveryDateAdded`,`usr`.`Name` AS `ReportDeliveryUserAdded` from ((`labtech`.`reportdeliveries` `rd` join `labtech`.`ltreports` `rep` on((`rd`.`LTReportID` = `rep`.`LTReportID`))) join `labtech`.`users` `usr` on((`rd`.`UserIDAdded` = `usr`.`UserID`)))