Hi,

We've got a diary service on our intranet which we've now to provide email
reminders at the end of each week to those who've not yet put up their diary
for next week.

I'm not sure on the SQL query I can make to list those users who have not
yet posted their diary info.

I've been able to list those users from the Employee Table who have an entry
in the Diary table for a specific week, but how do I list employees who do
not have an entry?

Regards
Craig.


_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp