Re: Need help with outer join question ?

From: Tom Reid <thomas_p_reid_at_hotmail.com>
Date: 20 Jun 2001 06:13:47 -0700
Message-ID: <6dfc26f.0106200513.19f22b8@posting.google.com>

thomas_p_reid_at_hotmail.com (Tom Reid) wrote in message news:<6dfc26f.0106200218.3be5e759_at_posting.google.com>...
> Given the following three tables:-
>
> Price_table
>
> Price Date Price
> ---------- -----
> 16-JUN-01 2.4
> 18-JUN-01 2.3
>
>
> Hilo_table
>
> Price Date Hi_pr Lo_pr
> ----------- ----- -----
> 17-JUN-01 2.45 2.35
> 18-JUN-01 2.35 2.25
>
>
> Volume_table
>
> Volume Date Volume
> ----------- -------
> 16-JUN-01 10000
> 17-JUN-01 10101
>
> I need a query to produce a 4th table as:-
>
> Date Price Hi_pr Lo_pr Volume
> ---- ------- ----- ----- ------
> 16-JUN-01 2.4 10000
> 17-JUN-01 2.45 2.35

Correction, Above line should read *************** 17-JUN-01 2.45 2.35 10101

> 18-JUN-01 2.3 2.35 2.45
>

>
> I can't seem to get the query I need, I'm presuming some kind of
> outer join is required. Any help would be appreciated
Received on Wed Jun 20 2001 - 08:13:47 CDT