Lookup a field from one table to another based on multiple fields

[shanmathytitu]

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.