SQL & PL/SQL

Hi

If I full outer join a table (schema A) with a view on another schema (schema B) and the view is selecting from another view on the same schema (schema B) then the only way to get this to work is to add a synonym in schema A to both views on schema B. HOWEVER, you only need to add the synonym to the first view if you do not use a full outer join. Maybe this is a bug, maybe not, I can live with adding synonym to both views which seems to work. BUT...Now in a different example I am getting ORA-00918: column ambiguously defined errors when everything is fully qualified. If I run both parts of the full join they work seperately, but when they are full outer joined I get the error, even if everything is qualified or I just select 1 as 'test' from the full join; this leads me to suspect the ON conditions, but they all seem to be ok too.

Anyone else had problems with full outer join across views/schemas ?