Finding "matching" records in first table against partial words in second table

[csnw]

I am stumped on how to do this.
Table 1 has a column company name with value "The Museum Store"
Table 2 has 5 columns wold1, word2, word3, word4, word5. word1 = "The", word2="Store"

As long as the words in Table 2 exists in Table 1, the record should be printed, in this case, it matched on "The" and "Store"

I am a novice with SQL; but this doesn't appear to be something easily solved with a SQL join but rather with a table scan of some sort?

Thanks much in advance,
--Ed

[ck9663]

Use the LIKE operator and the '%' wildcard character.

If you still have problem, post your T-SQL here.

Happy Coding!!!

~~ CK