Re: Sql question

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 Mon Dec 23 2002 - 19:01:30 CST