Make sure it's OUTER, so you get all records. :) Mike
-----Original Message----- From: Will Swain [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2008 8:33 AM To: cf-talk Subject: RE: Slotting dates into standard date range Both sets of data will be stored in a db, standard and non standard opening hours. Thanks Mike, doing a join on the tables makes sense to me. Cheers Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
