筛选测评项目的SQL

public final static String SELECT_EPS_PROJ_TREE1 = " select C.*,D.*,F.* from "+
  " (SELECT * FROM"+
  "     (SELECT PROJ_ID AS PROJID,PROJ_SHORT_NAME,PROJECT_FLAG   "+
  "       FROM DBO.PROJECT WHERE DELETE_SESSION_ID IS NULL AND BATCH_SUM_FLAG='Y'  "+
  "       and orig_proj_id is null)A,  "+
  "     (SELECT WBS_ID,PROJ_ID,WBS_SHORT_NAME,WBS_NAME,PARENT_WBS_ID ,PROJ_NODE_FLAG  "+
  "       FROM DBO.PROJWBS WHERE  DELETE_SESSION_ID IS NULL AND PROJ_NODE_FLAG='Y' )B "+
  "    WHERE A.PROJID=B.PROJ_ID  "+
  " ) C "+
  " left join "+
  " (select t2.proj_catg_short_name,t1.proj_catg_type_id,t1.proj_id ,t1.proj_catg_id from "+
  "     PROJPCAT t1 left join PCATVAL t2 on t1.proj_catg_id = t2.proj_catg_id "+
  " ) D on C.proj_id = D.proj_id "+
  "  left   join   "+
  "  (select * from  "+
  "   (select udf_type_id as udf_typeId,proj_id,udf_text from dbo.udfvalue ) as udf, "+
  "    (select udf_type_id,udf_type_label from dbo.udftype    where table_name='project'   "+
  "       and udf_type_label in ('进度整体评价','费用整体评价','质量整体评价','安全整体评价'))as udfid  "+
  "    where  udf.udf_typeId=udfid.udf_type_id  "+
  ")F on F.proj_id=C.projid ";