Folks,

I have the following procedure...

INSERT INTO #tempDailyStatistics

SELECT outcome AS [Outcome], COUNT(outcome) AS [Total]

FROM liveHistory

GROUP BY outcome

INSERT INTO #tempDailyStatistics

SELECT outcome AS [Outcome], COUNT(outcome) AS [Total]

FROM expiredHistory

GROUP BY outcome

Whick works perfect apart from one simple flaw. That is if I run the report

for today, I get all the outcomes for today only. What I want is EVERY

single outcome in the table, even if an outcome isn't related to today. How

can this be done?

TIA