select a.*,sysdate-b.op_date time_dif from whms_detail a,
(
select whms_material_detail_id,max(in_date) op_date from
(
select w1.whms_material_detail_id, w1.in_date from iitdb.whms_ in w1 where w1.valid_flag =1
union
select w2.whms_material_detail_id, w2.out_date from iitdb.whms_ out w2 where w2.valid_flag =1
)
group by whms_detail_id
having sysdate-max(in_date)>30 ) b
where a.whms _detail_id = b.whm _detail_id
and a.valid_flag = 1
// 这里的sysdate是系统时间