flag to be counted with sql select

with a SQL SELECT how can i know if the object must be counted for each year???

(table objects: code,date_in,date_out)
(table years)
Received on Tue Apr 30 2002 - 10:50:14 CDT