Limitations on OUTER JOIN

Filter conditions that use the operators [NOT] IN, ANY, ALL, BETWEEN, EXISTS, and sub-queries are not supported.

Example

SELECT * FROM emp LEFT OUTER JOIN dept ON dname IN ('Software', 'Marketing');