Worksheet Query

[Willio]

Hello,

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?

Thanks...

Willio

[Oly701]

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?

[Willio]

No there isn't.

When a worksheet is filled it will appear in de worksheet table.