operation on previously loaded data

[#1]

hi!!

please suggest answers for following problem.

i have a preloaded table from which i m retrieving a field using following code..

abc:
LOAD "ITEM_ITEM_CODE"
RESIDENT item_master;

now by using data of "ITEM_ITEM_CODE" in following manner

substr( "ITEM_ITEM_CODE",4,12)=model_model_code

i have to load data of model_master.

please suggest the exact code.

[#2]

Hi,

look for "Where Exists" or a Join statement.

Provide exact code is not possible without knowing more details (datasources, etc.).

Rainer