Where condition from another table column

[#1]

Hi,

Please help in the below scenario:

Load A1,A2,A3 from A

I want to load B in such a manner -

Load B1,B2,B3 from B where B1 = A1

I tried the above way but it is showing A1 column not found.

Please help how to achieve the above.

Thanks,

Girish Inani

[sunny_talwar]

May be use Where Exist here:

LOAD A1,

          A2,

          A3

FROM A;

LOAD B1,

          B2,

          B3

FROM B

Where Exists(A1, B1);