select t1.id,t1.parent_sys_fun_point_id,t1.sys_fun_point_type,t1.sys_fun_point_state,t2.sys_fun_point_ver,
t4.sys_fun_point_name ,t2.create_time,t4.sys_fun_point_code,t4.sys_fun_point_desc,t2.sys_fun_point_info_id,t1.sys_fun_point_layer
from req_system_function_point t1,
(
select distinct t.sys_fun_point_id,t.sys_fun_point_ver,t.sys_fun_point_info_id,t.create_time,t.sys_ver
from req_sys_fun_point_version t
where t.sys_ver <= (select tt.cur_sys_ver from req_sys tt)) t2,
req_sys_fun_point_info t4
where t1.parent_sys_fun_point_id is not null
and t1.id = t2.sys_fun_point_id
and t4.id=t2.sys_fun_point_info_id
and t1.sys_fun_point_state = 0
and
t2.sys_ver=(select max(t3.sys_ver) from req_sys_fun_point_version t3 where t1.id=t3.sys_fun_point_id );
posted on 2009-11-25 14:58
David1228 阅读(3877)
评论(0) 编辑 收藏 所属分类:
数据库