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;