sql - Left Outer Join using + sign in Oracle 11g - Stack Overflow

sql - Left Outer Join using + sign in Oracle 11g - Stack Overflow

瀏覽:797
日期:2024-05-15
TableA LEFT OUTER JOIN TableB is equivalent to TableB RIGHT OUTER JOIN Table A. In Oracle, (+) denotes the "optional" table in the JOIN. So in your first query, it's a P LEFT OUTER JOIN S. In your second query, it's S RIGHT OUTER JOIN P. They're ......看更多