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
