oracle外连接一个例子

with tmp1 as
(
select 1 l_id,‘a’ l_name from dual
union all
select 2 l_id,‘b’ l_name from dual
union all
select 3 l_id,‘c’ l_name from dual
),
tmp2 as
(select ‘b’ l_name,98 l_score from dual
union all
select ‘c’ l_name,60 l_score from dual
union all
select ‘d’ l_name,50 l_score from dual
)
select * from tmp1 a,tmp2 b where a.l_name=b.l_name(+)
order by a.l_id