Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ah, I understand now. Ok, plan B. Let's try nullcount(). See attached example
This one works perfectly .. thank you once again