如题oracle自然连接到底去除了哪些重复列?
------解决方案--------------------
NATURAL JOIN operation
A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based
on the common columns in the two tables being joined.
Common columns are columns that have the same name in both tables.
A NATURAL JOIN can be an INNER join, a LEFT OUTER join, or a RIGHT OUTER join.
The default is INNER join.
------解决方案--------------------
自然连接应该是消除了名字相同的两列,因为自然连接是以列名来判断的,但是自然连接用的很少,因为名字相同的两列内容可能完全不同。