Nested load resident/from qvd file like nested select statement

[#1]

Hi All

Instead of a nested select statement such as select * from table 1 where name IN (select title from table2), how can I do that with resident tables or load from qvd files?

I know from a previous posting I can use Match instead of the In but I don't know how to do a nested select statement.

Thanks

[Oleg_Troyansky]

Jack,

QlikView doesn't support nested LOADs. You can use WHERE exists() as a workaround for the IN (SELECT ...) logic. Also, look at the keyword KEEP, it might give you what you are looking for...

best,

Oleg