将2条select语句进行关联查询

sql:

with tmp_tab_1 as 
(select * from(
  select f.id ID , f. fund_group_id FUND_GROVP_ID , f. fund_id FUND_ID , f. fund_percent FUND_PERCENT,u. fund_SHORT_NAME
   , n. status SALE_STATVS
  from T_PRD_FUNDGROUP_DETAIL f left join T_PRD_FUND u on f. fund_id = u. fund_CODE left join T_PRD_FUND_MANAGE n on
   u.fund_CODE = n.fund_id
  ) f1 where f1.id =2
),
tmp_tab_2 as
( select * from (select t.id,t.fund_id ,g.group_name from t_prd_fund_manage t left join t_prd_fundgroup g on t. id=g. id)
)
select * from 
(select * from tmp_tab_1 t where 1 = 1) t1
left join
(select * from tmp_tab_2 t where 1 = 1) t2
on t1.id = t2.id

范例:

with tmp_tab_1 as 
(
select 1 id,'a' name,1 type from dual
union all
select 2 id,'b' name,1 type from dual
union all
select 3 id,'c' name,1 type from dual
union all
select 4 id,'d' name,2 type from dual
union all
select 5 id,'e' name,2 type from dual
),
tmp_tab_2 as
(
select 1 id,'a' name,1 type from dual
union all
select 2 id,'b' name,1 type from dual
union all
select 3 id,'c' name,2 type from dual
union all
select 4 id,'d' name,2 type from dual
union all
select 5 id,'e' name,1 type from dual
)
select * from 
(select * from tmp_tab_1 t where t.type = 1) t1
left join
(select * from tmp_tab_2 t where t.type = 1) t2
on t1.id = t2.id