Comparison or LOGIC issue *Newbie

[emparc]

Hello Gurus,

I am a newbie to SQL without any formal training (using Navigator 5) and reached a dead-end on trying to figure out the logic and the coding I need to make this work ! Your assistance is GREATLY appreciated ! heres my problem....

I need to segregate all the records in the cabinet based on the LAST_DATE that that a cabinet was opened (before April 2007) and all records ( recs_import_date ) not touched by cabinet on or before that DATE. The problem is the results I get produce all records opened before 4/1/07 BUT When I bounce all the cabinet/records off a list of cabinet/records opened after that date I get he same cabinet/records.

The problem is that I need a script solution that will produce ONLY those records where the cabinet/reocrds was opened before the April date and has NOT been opened or touched after that date.


My logic would be something like * Provide only those records that were imported before '01-apr-2007' and have not been touched after that date or if the below script could work it would look something like ???

select distinct cabinet, recs_import_date,
(case when recs_import_date >= '01-apr-2007' then '1' else '0' end) Last_date
from data_table
where
import_date <= '31-mar-2007' and not > '01-apr-2007"
group by recs_import_date, cabinet
order by
Last_date;