Query part of a field for data found in another table

[WalkOfShame]

I want to query a table to find all the records where there is a match between a string of characters in one column and a field in another table. The issue is that there is other data to the left and right of the relevant string in the first table, so I need to figure out a way to match only part of the field. See below for clarification

Table1
Johnny_Edwards_1234------Data1
Mike_Clinton_1234-----------Data2
Billy_Bobby_123--------------Data3
John_Wayne_590812--------Data4
Ryan_Clarke_0823-----------Data5


Table2
Edwards------ASDF1
Bobby---------ASDF2
Clarke---------ASDF3

I want the Query to return to following:
Edwards----Data1
Bobby-------Data3
Clarke-------Data5

 

[DBITeng]

select table2.field1,tabel1.field2
from table1,table2
where instr(table1.field1,table2.field1)>0

try this, should give you the basics

Technological progress is like an axe in the hands of a pathological criminal