Monday, September 21, 2009

OWB 10.2.0.4 outer join PEBKAC fix

Looking at a join Mr. someone-else had made in a OWB mapping I found the following conditions:
a.column1 = (+) b.column1 AND
a.column2 = (+) b.column2
Noway this can work! However the mapping was running smoothly. OWB actually changes the place of the (+) to the correct location when generating the SQL so that the final statement looks like:
a.column1 = b.column1 (+) AND
a.column2 = b.column2 (+)
I was totally amazed by this.