Full Outer Joins in OWB
By Jean-Pierre Dijcks on Jul 22, 2008
One of the questions I noticed recently was on full outer joins. How do you do that in OWB. Well it is quite simple, but I guess not that obvious. So here is a quick post on how to do this.
Here we have a simple mapping, where I join on code. I want to get all records (yeah not a great business case I know) from both tables, so I know if there are records on either side without matches.
My join looks like this:
Now if I complete the mapping to look like this, I can generate code.
As you see by default (this is OWB 10.2.0.3) you get an ANSI join syntax:
Want something not ANSI, go to configuration on the mapping and uncheck the ANSI SQL Syntax code option. Note that if you are doing Multi Config, you can change this per deployment of the mapping...