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);