>I have a table of all the employee's that need to turn in a time sheet. I have another table that is marked .t. when a time sheet is submitted. I need an SQL that will list thoes that have not turned in a time sheet.
I assume :
EMPLOYEE
EmpId
Other fields .....
TIMECARD
EmpId
Submitted
DateTime ....
OtherFields ....
This will work :
SELECT Employee.* ;
FROM Employee ;
WHERE NOT EmpId IN (SELECT EmpId FROM Timecard WHERE Submitted)
Cheers,
Jamie
Cheers,
Jamie