RE: Select dates from Table 1 not in Table 2

At 11:55 23/09/01 +1000, you wrote: Thanks Will for the suggestion, however as per my private email to you, it didn't work successfully to any degree. Actually it knocked out ONE date from the same group and that was one of the Available dates. I'll take my foot out of my mouth now and

RE: Select dates from Table 1 not in Table 2

, it should be plenty fast. -Original Message- From: Adam Todd [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 12:29 AM To: [EMAIL PROTECTED] Subject: Select dates from Table 1 not in Table 2 Hi all, just subscribed. Normally I work these out for myself, but time

Select dates from Table 1 not in Table 2

Hi all, just subscribed. Normally I work these out for myself, but time and frustration are winning. I have two tables: SCHEDULE which contains a column called date and in that are DATETIME entries from 2001-09-14 to who cares. NONAVAIALBLE which contains users and dates they aren't

RE: Select dates from Table 1 not in Table 2

[mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 12:29 AM To: [EMAIL PROTECTED] Subject: Select dates from Table 1 not in Table 2 Hi all, just subscribed. Normally I work these out for myself, but time and frustration are winning. I have two tables: SCHEDULE which contains