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

RE: Select dates from Table 1 not in Table 2

ably, the fact that it takes 4 steps may not be as simple as you >would like... but with only a max of 200 output records, it should be plenty >fast. > > > -Original Message- > > From: Adam Todd [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 21, 2001 12:29 AM

RE: Select dates from Table 1 not in Table 2

m 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 > and frustration are winning. > > I ha

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 availa