I have 2 tables:
Employee: EmployeeID, name
Worksheet: WorksheetID, Week, Year, EmployeeID, Hours
The worksheetrecord stores the hours worked by an employee. What i want to know is: Which Employee has no worksheet in a specific year and week.
For instance for year 2006 and week 21. That sql tells me that Employee 5 and 9 doesn't have a worksheet with week 21 and year 2006.
Is this possible and how?