Is there is 1:1 or 1:N relationship between file and table?if there is 1:N you cann't perrform look-up.please explain more about this.
vsi wrote:I have a file with fields field1,field2,field3,field4,field5,field6,field7. and a table with columns col1,col2,col3,col4,col5,col6,col7,col8. i have to perform a lookup from file to the table and retrieve the col8 from the table.
some of the fields of the file may contain "*" as values, then match with the remaining columns and retrieve the col8 from table.
example :record in the file 101,10,*,30,40,50,60
in the table 101,10,20,30,40,50,60,1001
101,10,70,30,40,50,60,1002
result should be 1001
1002
need ur help to solve this.
Thanks in advance