tab1:
Load Policynum,lpolnum,lacepolicynum,corporatepolicynum,
Agencyname
from tab1;
Maintab:
Load Policynum,lpolnum from Maintab;
My requirement: i need to load Agencyname in Maintab table based on Policynum,lpolnum with tab1 (Policynum,lpolnum,lacepolicynum,corporatepolicynum).
I.e., lookup Maintab(Policynum,lpolnum) and tab1(Policynum,lpolnum,lacepolicynum,corporatepolicynum) to get the Agencyname;
This Maintab(Policynum,lpolnum) can be anythg from tab1(Policynum,lpolnum,lacepolicynum,corporatepolicynum).
Note: Policynum,lpolnum from Maintab can we anything in tab1 Policynum,lpolnum,lacepolicynum,corporatepolicynum.
I need to get the Agencyname from tab1 to Maintab(final table).
Please assist.