Query for not exact matches in two tables

[FrankBone]

I have a table listing 50 commonly used terms and want to query another table for records containing those terms as just part of a field. For example one term might be "MERCHANT BANKCARD" and the field I want to query will have "MERCHANT BANKCARD 05292015 9995555467" or something similar that varies. I want to find all records that contain that sequence of text. Similar to using Like "MERCHANT BANKCARD*" but for a list. Does this make sense? Thanks for any help.

[June7]

Maybe:

SELECT table2.* FROM table2, table1 WHERE table2.field LIKE "*" & table1.field & "*";

or

SELECT table2.* FROM table2, table1 WHERE InStr(table2.field, table1.field)>0;

or

SELECT table2.* FROM table2 WHERE DCount("*", "table1", "InStr('[field]', '" & [field] & "')>0")>0;