Re: Merge result of two queries?

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sun, 08 Jan 2006 19:28:29 +0000
Message-ID: <5bo2s15bpt0v6gikptao68i6qp2k3kfpmi@4ax.com>

On Sun, 08 Jan 2006 10:48:43 -0800, DA Morgan <damorgan_at_psoug.org> wrote:

>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.

Yes there are. Reread the OP's post; look at "SQL2".

-- 
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

Received on Sun Jan 08 2006 - 13:28:29 CST