is it possible with sql?

 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 - 08:36:46 CDT