Forum Discussion
Stevenson Yu
Jun 12, 2017Brass Contributor
Full Outer Join not working in Version 1707 (Build 8231.1000)
Assume there two tables. One table contains the following: A B C The other table contains the following: D E F A full outer join, after expansion, should create a new table with two colu...
- Jun 13, 2017
Hi Stevenson,
That's correct behaviour for Full Outer join, it returns records from both tables with null in other column for not-matching records.
See, for example, http://www.dofactory.com/sql/full-outer-join
SergeiBaklan
Jun 13, 2017Diamond Contributor
Hi Stevenson,
That's correct behaviour for Full Outer join, it returns records from both tables with null in other column for not-matching records.
See, for example, http://www.dofactory.com/sql/full-outer-join