Selecting the NULL values

[#1]

Hi all,

This is what I want to do.

Table1 Structure=> AccountName,TotalPosition -- this is loaded from a flat file in a QVD

Table2 Structure=>AccountName,BusinessName -- this is loaded from a flat fiel in a QVD

Not all AccountName in Table1 are present in Table2, that is the relation between Table1 and table2 is 1->0,1

In one report, I show BusinessName,AccountName,TotalPosition -- suppressing any missing business name. Quite OK.

In another report, I need to show all AccountNames which do not belong to a BusinessName. That is, in an SQL sort of way:

select AccountName,TotalPosition from Table1 a where not exists (select 1 from Table2 b where a.AccountName=b.AccountName)

Any idea how to do it ?

Message was edited by: tapodevc -- adding the example QVW

[Gysbert_Wassenaar]

Ah, I understand now. Ok, plan B. Let's try nullcount(). See attached example

[#3]

This one works perfectly .. thank you once again