Merging the results of three queries

["Benzenhafer, Dave" <DBenzenhafer@HOUSTON.DEEPWATER.COM>]

I am using SQR 4.3.4
I have three queries that output a date and a quantity.

Query 1 Output                Query 2 Output                    Query 3
Output
Date                Qty            Date                    Qty
Date                        Qty
01-OCT-01        2            01-OCT-01             3              02-OCT-01
6
02-FEB-02         3            05-JAN-02             2
12-DEC-01                 8
03-FEB-02         5            03-FEB-02              5
03-FEB-02                 9

I would like to merge the three results in to something that looks like
this.

Date            Output 1            Output 2            Output 3
01-OCT-01        2                        3                        0
02-OCT-01        0                        0                        6
12-DEC-01        0                        0                        8
05-JAN-02        0                        2                        0
02-FEB-02        3                        0                        0
03-FEB-02        5                        5                        9

I don't want to have to query each day of the year.
Any suggestions will be appreciated.


Dave Benzenhafer
EMPAC Custom Reports
(601) 792-4857  (601) 714-6970
dbenzenhafer@houston.deepwater.com