Re: Sql question

Sorry for my english

it's not trimestry but trimester (3 months)  I don't say reply events but something like "replay" or "repetition" events (same event on same object with 2 dates in the same trimester)

"Bert Bear" <bertbear_at_NOSPAMbertbear.net> a écrit dans le message de news: KlON9.148$ga2.118771772_at_newssvr11.news.prodigy.com...
> Michel,
>
> I'm sure there is a way to do what you desire, but I can't make heads or
> tails of your request. I'd like to help, but for exampe:
>
> What are reply events?
> What is a trimestry?
>
> In fact, I can't understand enough to ask questions (IMHO).
>
> Anyway, also, please include Oracle version, operating system version,
> hardware, etc. Why? Different versions have different features and way
of
> coding SQL.
>
> Bertram Moshier
> Oracle Certified Professional 8i and 9i DBA
>
> http://www.bmoshier.net/bertram
>
>
>
> "michel guerillot" <michel.guerillot_at_free.fr> wrote in message
> news:3e07508a$0$17169$626a54ce_at_news.free.fr...
> >
> > Hi,
> >
> > is it possible using only SQL selects ?
> >
> > i have 2 tables (fields)
> >
> > objects(code,desc) and events(event_code,date_Event,object_code)
> >
> > join by objects.code=events.object_code
> >
> > my problem is to know for each object (also if it has no event) the
number
> > of "replay events" in the trimestry ( counted only if the same objects
had
> > one or more event in the previous trimestry ....date_event-90.....)and
> the
> > number of events in the trimestry
> >
> > something like this graphicly
> >
> > objects replay _events events
> > --------------------------------------------
> > obj1 2 4
> > obj2 0 2
> > obj3 1 3
> > obj4 0 0
> >
> >
> >
> > thanks
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
Received on Tue Dec 24 2002 - 09:41:03 CST