Re: Outer join

Wolfgang

All your rows have the same column values except for the amtN columns, the PD column and the two (currency?) columns which appear to be C14 and C15, and C13 (with values B and U). By the way, the PD and FY columns appear to be reversed (surely FY would be 2008 and PD would be 1 to 4).

In foo_tmp you have one set of 12 rows for C13='B' (4 values for PD * 3 currency combinations) but you have *two *sets of 12 rows for C13 = 'U' - making 24 rows compared to the 12 rows for C13='PD'.

So naturally given 2 rows in the input for each distinct tuple in foo_tmp you get 2 rows in the output... or am I missing something

And they are sorted (what was the plan - a sort merge?) so like rows are shown together (rather than being in the order shown for foo_tmp)

Regards Nigel

2008/11/10 Wolfgang Breitling <breitliw_at_centrexcc.com>

> Can someone show me the errors of my way, please.
>
>

--
http://www.freelists.org/webpage/oracle-l