SELECT Training_Log.Train_ID, Training_Log.Train_Step, Training_Log.Employee, Training_Log.Train_Date,
Training_Log.Notes, Agency.Agency_Name, Employee.Last_Name
FROM #Request.prefix_db_lookup#.Training_Log, #Request.prefix_db_lookup#.Agency, #Request.prefix_db_lookup#.Employee
WHERE Training_Log.Agency_ID = Agency.Agency_ID
AND Agency.Agency_ID = #url.ID#
AND Training_Log.Created_By = Employee.Employee_ID
ORDER BY Train_Step ASC, Train_Date
MyHomecareBiz.com