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?
What happens if there is no worksheet? ie. Is there still a record with a null value for Hours or just a complete lack of data?
No there isn't.
When a worksheet is filled it will appear in de worksheet table.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)