Limitations on JOIN on views

A JOIN on a view that is created with a UNION clause is not supported.

Example

CREATE VIEW sampleView as SELECT deptno FROM emp UNION

SELECT deptno FROM dept;

SELECT * FROM sampleView s1, sampleView s2;