Ian Skinner wrote: > > Is there any problem mixing FROM ... JOIN clauses with WHERE joins?
No. > A question about part of the WHERE clause. Does this piece "EXTRACT (MONTH > FROM d.date) = #month#" have anything to do with getting the days since last > drive piece? Or, is it as I assume the code that selects the month of data > that I want. Getting the month of data. > Which is unfortunately more difficult for me, since the > designers of this database in the mists of the long forgotten past for some > reason of inexplicable wisdom chose to store all dates as numeric strings > yyyymmdd. Not hard at all: WHERE d.date LIKE 'yyyymm%' Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
