a表
id name sy_departid wx_departidB表
id departid departnamea表中的sy_departid和wx_departid 都是右连接b表中的departid我以前是做2个视图,才能实现:
过渡的视图
tmp_view
select a.id,a.sy_departid,a.wx_departid,b.departname as sy_departname from a,b where a.sy_departid=b.departid(+)然后再做一个最终的视图c_view
select tmp_view.id,tmp_view.sy_departid,tmp_view.wx_departid,tmp_view.sydepartname,b.departname as wx_departname from tmp_view,b where tmp_view.wx_departid=b.departid(+)能合成一个视图吗?
谢谢
id name sy_departid wx_departidB表
id departid departnamea表中的sy_departid和wx_departid 都是右连接b表中的departid我以前是做2个视图,才能实现:
过渡的视图
tmp_view
select a.id,a.sy_departid,a.wx_departid,b.departname as sy_departname from a,b where a.sy_departid=b.departid(+)然后再做一个最终的视图c_view
select tmp_view.id,tmp_view.sy_departid,tmp_view.wx_departid,tmp_view.sydepartname,b.departname as wx_departname from tmp_view,b where tmp_view.wx_departid=b.departid(+)能合成一个视图吗?
谢谢
select a.id,a.sy_departid,a.wx_departid,b1.departname as sy_departname
b2.departname as wx_departname
from a,b b1,b b2
where a.sy_departid = b1.departid(+)
and a.wx_departid = b2.departid(+)