Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: simple sql question/mlml

Re: simple sql question/mlml

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/10/10
Message-ID: <61kjvb$mk6$4@news02.btx.dtag.de>#1/1

Michel Lee wrote:
>
> select t.amt, d1.per, d2.per, d3.per, d4.per
> from
> transactions t,
> fiscalyear d1
> where
> t.date1 between begin_date and end_date and
> t.date2 between begin_date and end_date and
> t.date3 between begin_date and end_date and
> t.date4 between begin_date and end_date ;
 

-- 
Regards

M.Gresz    :-)
Received on Fri Oct 10 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US