SELECT
ENROLLMENTS,
FOLLOWUPS,
OUTCOMES,
REPORTDATE
FROM dailyActivity
where (
reportDate BETWEEN '2010-10-09' AND '2010-10-12'
or
reportDate is null
)
AND traxUserID = XXXXXX
Ray Thompson
Tau Beta Pi Headquarters
865-546-4578
www.tbp.org
-----Original Message-----
From: Torrent Girl [mailto:[email protected]]
Sent: Thursday, March 17, 2011 3:45 PM
To: sql
Subject: Date Range with Null Records
I have this query that I am using to bring back a range of data:
SELECT
ENROLLMENTS,
FOLLOWUPS,
OUTCOMES,
REPORTDATE
FROM dailyActivity
where reportDate BETWEEN '2010-10-09' AND '2010-10-12'
AND traxUserID = XXXXXX
My dilemma is that I want to bring back a record for the date that does not
have any records.
How can I do that?
TIA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:3398
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
