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

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 have created a tmp_table for use, for some reason I can't create TEMPORARY table

RE: Select dates from Table 1 not in Table 2

Try this: CREATE TEMPORARY TABLE tmp_avldate (date datetime, nadate datetime); INSERT INTO tmp_avldate (date, nadate) SELECT DISTINCT schedule.date, nonavailable.date FROMschedule LEFT JOIN nonavailable ON schedule.date = nonavailable.date; SELECT dat