Have you looked into data blending? The following links provide further information:
Hope this helps a bit!
I have the same question, did you ever figure it out?
I have the same question.
Is there a way to join two tables using "CONTAINS"?
I was able to use this format
FROM A INNER JOIN
B ON A.ID = B.ID INNER JOIN
C ON C.ID1 = B.ID1 INNER JOIN
X ON X.Name LIKE '%' + W.Name + '%' AND
LIKE '%' + W.Name2 + '%' AND
LIKE '%' + W.Name3 + '%'
I just plugged in my column names and tables where they fit and it worked exactly the way I wanted, let me know if you have any more questions or attach a workbook for more specific help!