Skip to content

Subquery

April 15, 2008

This query is not returning any record because internal query returns null along with other rn_product__code, and which in turn returns “no rows selected” by external query because any operations on null returns null.

So for :

select code from A where code not in (select f_code from B where f_code is not null)

important to check f_code not null else the complete query returns no records returned.

🙂

Advertisements

Comments are closed.

%d bloggers like this: