SELECT *
FROM #Request.prefix_db_agency#.Homework,#Request.prefix_db_lookup#.Employee
Where Homework.Agency_ID = #url.ID#
AND Employee.Employee_ID = Homework.Employee
AND Homework.DateCreated > '2016-01-01'
ORDER BY Homework.DateCreated DESC
HHA System Administration
Superadmin Home