я замечаю что в Microsoft SQL Server topic никто не хочет ( или не может) онvечать поэтому, наверное опять не по теме...

Кто то может помочь с query.
Вот что требуется:
Наити мин unaudit_date , потом мах audit_date ( где actual_time_in < мин unaudit_date ).

Вот что есть, но в некоторых случаях мин unaudit_date is NULL, поэтому я не получаю нужных результатов.
Спасибо за помощь

SELECT aircraft_data.oid aircraft_oid,
Aircraft_data.Aircraft_id ,
Aircraft_data.Fleet_Oid ,
Aircraft_data.Fleet_Type_Oid ,
Aircraft_data.Total_Time,
Aircraft_data.Total_Landings ,
Aircraft_fleet.Description ,
Aircraft_fleet_Type.type_id ,
Aircraft_data.flight_data_oid,
flight_data.destination_oid ,
flight_data.actual_time_on ,
flight_data.log_page,
aircraft_data.starting_time,
aircraft_data.starting_landings,
"audit_date" = (select max(actual_time_in)
from flight_data
where aircraft_oid = aircraft_data.oid and
status_sym = 'Completed' and
actual_time_in < (select min(actual_time_in)
from flight_data
where aircraft_oid = aircraft_data.oid and
audited_sym = 'false' and
status_sym = 'Completed')),
min(actual_time_in),
sum(flight_time),
sum(landings),
max(actual_time_in)
FROM Aircraft_data (NOLOCK) ,
Aircraft_fleet (NOLOCK),
Aircraft_fleet_Type(NOLOCK),
flight_data (NOLOCK)
WHERE ( Aircraft_fleet.Oid = Aircraft_data.Fleet_Oid) and
( Aircraft_fleet_Type.Oid =* Aircraft_data.Fleet_Type_Oid) and
( Aircraft_data.Status_Sym = 'Active' ) and
( Aircraft_fleet.description in('727', '747') and
(aircraft_data.aircraft_id <> 'SUBCONTRACT')) and
aircraft_data.flight_data_oid *= flight_data.oid

Group by
aircraft_data.oid,
Aircraft_data.Aircraft_id ,
Aircraft_data.Fleet_Oid ,
Aircraft_data.Fleet_Type_Oid ,
Aircraft_data.Total_Time,
Aircraft_data.Total_Landings ,
aircraft_data.starting_time,
aircraft_data.starting_landings,
Aircraft_data.flight_data_oid,
Aircraft_fleet.Description ,
Aircraft_fleet_Type.type_id ,

flight_data.oid,
flight_data.destination_oid ,
flight_data.actual_time_on ,
flight_data.log_page,
flight_data.flight_time,
flight_data.landings,
flight_data.actual_time_in

Спасибо за поддержку