Problem with FULL OUTER JOIN

[klkuab]

I am trying to run the following sql but am getting an Oracle error ORA-00918: column ambiguously defined

select b.acct_unit, sum(b.budget_amount),
sum(s.spend_amount)
from uabhssd.vwuabbudget b full outer join
uabhssd.vwuabspend s on
b.fiscal_year = s.fiscal_year and
b.acct_period = s.acct_period and
b.account = s.account
group by b.acct_unit, s.acct_unit

it executes fine if I replace the "full outer join" with either "right outer join" or "left outer join", however I need to use the "full outer join" to return the results that my users want.

thoughts, ideas?

 

[elsenorjose]

You might get better results posting this in an Oracle forum since this is a general ANSI SQL forum. It sounds like it's a limitation of Oracle's implementation of SQL.

Best of luck!