Yes shammat - I concur with your findings.

Running the same test on 10g (10.2.0.3.0) the error does not occur.

My simplified test scenario is thus:

CREATE TABLE mytable (mycol NVARCHAR2(10), mycol2 NVARCHAR2(10));

CREATE VIEW myview AS SELECT mycol AS v_mycol, mycol2 AS v_mycol2 FROM mytable;

SELECT mycol
FROM mytable
INNER JOIN myview ON mytable.mycol = myview.v_mycol;

- Above works on 10g (10.2.0.3.0) but fails with “ORA-00918: column ambiguously defined” on 11g (11.1.0.7.0)

SELECT mycol
FROM mytable
LEFT OUTER JOIN myview ON mytable.mycol = myview.v_mycol;

- Above works on both 10g and 11g.

I have raised a log through Metalink.

Will post a reply when I hear anything.

Andy