Re: Sql question

Michel,

Not a problem on the English.

FYI (For Your Information), trimester (3 months) is BETTER known as "quarter" (1/4 of a year = 3 month). I'll go back now and re-read the original note.

Bert.

"michel guerillot" <michel.guerillot_at_free.fr> wrote in message news:3e087f8e$0$29928$626a54ce_at_news.free.fr...
> 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 Wed Dec 25 2002 - 14:15:39 CST