Query not ging result

[pm_witmond]

Hi,

Can anybody tell me why this query doesn't give any records ?

select * from "HANA_CONTAINER"."@OCRD" t0

where t0."U_ACCT_TYPE"='DEB'

and  t0."Code" not in (Select distinct "U_CardCode_ORG" from "SBO_V3"."OCRD" where "CardType"='C' order by "U_CardCode_ORG")

Table "HANA_CONTAINER"."@OCRD" has 33138 records

Table "SBO_V3"."OCRD" has 32035 records

Can someone please help ?

Thanks,

Paul

[Former Member · Accepted solution]

Probably the selection condition on U_ACCT_TYPE in combination with the anti join condition on Code isn't fulfilled by any record. A record will only be returned if it fulfills all conditions in the WHERE clause. The result set is independent of the number of records in the tables.

[pm_witmond · Accepted solution]

Hi,

It took some time but finally i've found it.

The subquery returned some NULL values and these values stopped everything.