Limitations on UNION

Using a correlated column in a UNION sub-query is not supported.

Example

SELECT * FROM emp, dept d WHERE sal IN

(SELECT sal FROM emp WHERE d.deptno = deptno UNION

SELECT sal FROM emp);