Hi. I'm having trouble getting all the results I need with a query and hope its just my lack of experience.
Tables are Employee, Performance_log and Performance.
I need to see all Employees that have a performance_Log entry within a date range. (done)
Then I was asked to include employees that do not have an entry in the Performance Log table but only if they don't have an entry within the date range previously mentioned.
I feel like I am almost there. I can display all employees with performance logs and filter by date. I can display all employees without performance logs within the same query. My trouble is when an employee has a performance log
outside of the date range. The record should be included but its not. I've tried using not exists() and not in() in the where but haven't figured it out yet.
Here is the query (the 4th line of the OR is a work in progress and is changing by the minute as I search for the solution)
The dates will eventually be replaced with variables and saved as a stored procedure to be called by Crystal.
Employee.Employee_Id, Employee.Department, Employee.Active, Employee.NC_Type, Employee.NC_Full_Name,
View Complete Post