Re: Merge result of two queries?

Andy Hassall wrote:

> When you're talking about filling gaps, the first thing to think of is an
> outer join.

An outer join will not do what the OP asks as there are no records for the missing dates.

The choices are either build a table with every date and maintain it or, as I've suggested, link in a pipelined table function.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)