Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement
Message
 
To
27/08/2002 21:28:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00694300
Message ID:
00694301
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform