Where clause load comparing two tables field in Qlikview

[#1]

Hi All,

How can we compare two same fields across table 1 and table 2 and load the same in Qlikview like below script?

EG.,

Table1:

LOAD *;
SELECT A, B;
FROM Table1
WHERE Table1.A = Table2. A;

Thanks,

Swathi

[#2]

Thanks All...

[pho3nix90]

This is possible if Table 1 already exists and you need to limit table 2.

LOAD

     *

FROM Table2

WHERE Exists(A);