Sql question

From: michel guerillot <michel.guerillot_at_free.fr>
Date: Mon, 23 Dec 2002 19:08:10 +0100
Message-ID: <3e07508a$0$17169$626a54ce@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 - 12:08:10 CST