Lets say I have the following table
Id, Word, Description
1, apple, blah blah blah
2, banana, blah blah blah
3, orange, blah blah blah
4, plum, blah blah blah
5, peach, blah blah blah
6, grapes, blah blah blah
In a second table we have
WordID, SimilarWordID
3,4
3,5
1,3
If orange was selected, what would I need query wise to have a third table that excludes any Word regardless of
Id, Word
2, banana
6, grapes
I mean I could easily do the filtering manually from the program, but I'd prefer to do it all in SQL if it is possible to "simply" do.