LOAD from Resident table with condition and apply Map

[Anonymous]

Hi guys ,

i have 3 tables  Table1 ,table2 and table3

Table1 has fields : RefID ,etc...

Table2 also has RefID and so..

same as Table3

now my issue is :-

i load Table 1 first and then table2 but table2 needs to have only records where table2.RefID is in Table1.RefID

and as well Table3 will only load records that are in Table2.RefID along with a condition where Table3.Active=1

Would there be a way to flag if  RefID exits in table1.RefID ,Table2.RefID and Table3.RefID

Thanx

[marcus_sommer]

Try something like this:

t1:

Load * From a;

t2:

Load * From b where exists(RefID);

t3:

Noconcatenate Load * Resident t2 where Active =1;

- Marcus