2 step search - find results in search result

Hi forum, I'm new here and I've been having a problem to do a 2 step search.
Let me (try to) explain:

I've got 2 tables I need to compare

Table A (30 records)
name, Street, zip, town, Value 1

Table B (50000 records)
name, Street, zip, town

Step 1 - Compare the following to narrow it down
street, zip, town

Step 2 - once I've got a search result of step 1
compare the names from Table A with the result form Step 1

Step 3
Write the results from step 2 including "Value 1" of the Table A
name, street, zip, town, Value 1

I think I need to do 2 steps becuase the [name] in table A is mixed. I only have 1 filed called [name]. It can be [firstname] [lastname], [lastname] [firstname], [firstname] [second name] [lastname] etc..

That's just my approach. The main problem is that name field. If theres a way to do a wildcard search just for the name and and exact match for street, zip and town I'd be more than happy to do it in 1 step.

Thank you for your input.