how to achieve a subquery with qvd's

[#1]

can anyone explain how to achieve the following using qvd.

select ID, Name from Table1

where ID not in (Select ID from Table2).

i will like a qvd version.

thats is i want only the IDs from table1 where not Exist int Table2

[#2]

Where clause work on same table from where u loading..

its not u are loading from one table ,bt condition u r applying for other table

regards-bika

[Anonymous]

You have to load table 2 first, and use "not exists" when loading table 1.  See the very recent http://community.qlik.com/message/369556#369556

Regards,

Michael