SELECT Employee.Employee_ID, Employee.First_Name, Employee.Last_Name, Employee.Status, EmployeeLicenses.Employee_ID, EmployeeLicenses.Expiration_Date FROM #Request.prefix_db_lookup#.Employee, #Request.prefix_db_agency#.EmployeeLicenses WHERE Employee.Employee_ID = EmployeeLicenses.Employee_ID AND EmployeeLicenses.Expiration_Date BETWEEN #CreateODBCDate(Today)# AND #CreateODBCDate(Period)# AND Agency_ID = #session.AgencyID# AND Employee.Status = 'active' AND Employee.EmployeeType != 'Physician'

Employees without licenses

#Last_Name#, #First_Name#