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: is it possible with sql?

Re: is it possible with sql?

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 02 May 2002 14:46:44 GMT
Message-ID: <ojcA8.94078$CH.13302@rwcrnsc52.ops.asp.att.net>


Brian,
It is easier if you get the professor's email address; then you can send the answer directly..
Jim
"Brian E Dick" <bdick_at_cox.net> wrote in message news:FbbA8.7046$MS5.364556_at_news2.east.cox.net...
> This isn't very hard. Is this for some class assignment? I'll sketch out
the
> query logic for you.
>
> 1) Join the tables by code_object
> 2) Constrain the rows to those having date_event between date_in and
> date_out
> 3) Count the constrained rows grouping by code_object
>
>
> "gil guerillot" <gil.guerillot_at_ratp.fr> wrote in message
> news:aarbt8$fuv$1_at_gotix.reseau.ratp...
> >
> >
> > i have 2 tables:
> >
> > (table objects: code_object,date_in,date_out)
> > (table events:code_event,date_event,code_object)
> >
> > join by code_object
> >
> > i' d like to know the number of events by object and by year.
> >
> > but i must count only the event when the object is there at the event
> > date(between date_in and date_out)
> >
> > how can i do with SQL ?
> >
> >
>
>
Received on Thu May 02 2002 - 09:46:44 CDT

Original text of this message

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