Re: SQL Question

From: Conan Farrell <conan_at_(remove_this)as-if.com>
Date: 26 Oct 1999 19:14:13 +0100
Message-ID: <01bf1fd5$ec38be20$b501ce0a@Cfarrell.snn.ie.sykes.com>

Jean,

        try this

select

   one.prod_date,
   one.mr_key,
   two.rate,
   one.volume

from

   one,
   two
where

   two.prod_date = (select max(prod_date)

                   from two tab2
                   where tab2.prod_date <= one.prod_date)

   and one.mr_key = two.mr_key -- Assumption on my part order by 1

it should produce

PROD_DATE MRKEY RATE VOLUME ___________ __________ __________ __________

01-OCT-1999          3       2828       3551
02-OCT-1999          3       2828       3582
03-OCT-1999          3       2828       3478
04-OCT-1999          3       2828       3556
05-OCT-1999          3       2900    3618.99
06-OCT-1999          3       2900       3565
07-OCT-1999          3       2900       3629
08-OCT-1999          3       2900    3596.01
09-OCT-1999          3       2900       3612
10-OCT-1999          3       2900    3597.01

HTH --
Conan Farrell
Oracle DBA Received on Tue Oct 26 1999 - 13:14:13 CDT