本文提供了一个使用SQL进行联合查询的例子，展示了如何通过创建临时表来完成数据匹配的过程。该示例涉及基本的SELECT语句、UNION ALL操作及外连接的使用。
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
扫一扫
评论
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
