CA OLQ OQ Messages › OQ143026

OQ143026

Nested SQL queries using IN are not supported. Reformulate the request to a single query level.

Reason:

Nested subqueries using IN and NOT IN operators are not currently supported. Rewrite your statement using a single-level request. For example, transform:

SELECT col1 FROM tab1 WHERE col1 IN (SELECT col2 FROM tab2)

Into:

SELECT col1 FROM tab1, tab2 WHERE tab1.col1 = tab2.col2

Module:

OLQSSCAN

Severity:

0