Performing query on a table, return value is null

The sample data is as such. So if Andy & Lau matches, it will get the last int value "99". The 99 is then use to search the second file and return related result such as 99 manager research and male

#Andy&Lau&9/17/2013 8:14:00 PM&andy@hotmail.com&commonwealth&africa&128000&99

#99&manager&Research&male #123&worker&cleaner&female