hi everybody,

I have to make a program where i have to search data into a table using a lookup table. The situation is like this

lookup table : 10000 records where there is field like postcode,address,name
searched table(S1) : 1.5 million records contains postcode, address, name etc

now using postcode from lookup table, i have to search it in S1. If found i have to compare address and if matched, i have to match the name. Once complete match is done, i have to pull that record out (which is easy. i hope!!).
If anybody can suggest me an approach which is fastest and effective, i would be very grateful.

Many, many thanks in advance