I have two tables, one containing a list of words that I want to match and
another containing a full list of words and a link field into another table.
I am trying to write a query that will select all the rows from table #Words
where the LinkID contains all the words in #SearchWords, for example the
tables below would only return 1 row, containing LinkID 1.
Obviously this cannot be done efficiently in a single query because of the
relationship issue. I was toying with the idea of iterating through each
row in #SearchWords and creating a temp ...