I have a table of text terms that I want to search a second table to see if any of the Text Terms in the first table exist in a description in the second table excluding itself.
For clarity purposes I have attached an excel spreadsheet that shows an example of what I'm looking for.
The first column of data is in table # 1 (tmpTextIDTable) and contains a single column of text entries labeled TextID.
Columns E and F reference table #2 (tmpTextMatchDetails) which contain two columns TextID and TextDescription.
TextId is the key field to join the two tables.
You will not that the rows marked with either yellow or green, contain a reference to one or more references to the TextID text from table 1, however references to its own TextID is excluded.
I essentially want to create a list that tells me which rows from table two have a reference to any of the textid excluding itself.
Does this make sense?
Thanks for any direction you have