今天看书也想过这个问题,这是一个完全连接的问题,但是我不会...
:(
试试:
select * from
(select ....) s1,
(select ....) s2
where s1.no=s2.no(+)
union
select * from
(select ....) s1,
(select ....) s2
where s1.no(+)=s2.no;
:(
试试:
select * from
(select ....) s1,
(select ....) s2
where s1.no=s2.no(+)
union
select * from
(select ....) s1,
(select ....) s2
where s1.no(+)=s2.no;
select * from
(select ....) s1 full join
(select ....) s2 on s1.no=s2.no
select ... from (select ....) s1 full outer join (select ....) s2 on s1.no=s2.no
sql伪语言如下:
select * from
(select ....) s1,
(select ....) s2
if exists(s1)
then
where s1.no=s2.no(+)
else
where s1.no(+)=s2.no;
但不知道怎莫写,上面那样写老报错,请大家帮我看看
select * from
(select ....) s1,
(select ....) s2
where s1.no(+)=s2.no;