>> I want to bring back a record for the date that does not have any records. > >If you re-read that, it sounds like you want to magically invent data >out of thin air? :P > > >Do you mean that, in addition to currently returned data, you also >want to include records that have a null/unknown date value? (So >they're not in the specified range, but they're not outside either.) > >If so, you just need to do an OR inside parentheses: > >SELECT <columns> >FROM dailyActivity >WHERE traxUserID = XXXXXX >AND ( > reportDate BETWEEN '2010-10-09' AND '2010-10-12' > OR > reportDate IS NULL > )
Well there are no records for 10/10/2010 but I need to include that date in the results with no records. Because it is not returned by the query, it is not displayed in the output. Since it is within the range, can I somehow include it in the query results? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3401 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
