表A,B,C 。表B可以连接到A,然后C可以连接到B
select ... from a,b, c
where a.xh = b.xh(+)
and b.xh2 = c.xh2(+);
但是不能C连接到A, 然后C又连接到B
select ... from a,b, c
where a.xh = c.xh(+)
and b.xh2 = c.xh2(+);此时会报 ora-01417:表可以外部连接到至多一个其它的表
表A,B,C 。表B可以连接到A,然后C可以连接到B
select ... from a,b, c
where a.xh = b.xh(+)
and b.xh2 = c.xh2(+);
但是不能C连接到A, 然后C又连接到B
select ... from a,b, c
where a.xh = c.xh(+)
and b.xh2 = c.xh2(+);此时会报 ora-01417:表可以外部连接到至多一个其它的表
转载于:https://www.cnblogs.com/herane/archive/2010/03/10/1682604.html