ORA-01417: a table may be outer joined to at most one other table

ORA-01417: a table may be outer joined to at most one other table
Cause: a.b (+) = b.b and a.c (+) = c.c is not allowed
Action: Check that this is really what you want, then join b and c first in a view.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01417：表可以外部连接到最多一个其他表,
.原因： ab（+）= bb和ac（+）= cc不允许,
.操作：检查这是否真的是你想要的，然后在视图中先加入b和c。,
.

aiaiDBA

13718043309

010-86462881

ORA-01417: a table may be outer joined to at most one other table

1 个回答

相似问题