Hi,
I am looking to generate all possible combinations of single words in column
"a" and to end up in a result1. I would then like to check to see if any of
the terms in column "b" match "Result1". If they do, display the final
result.
*please excuse my lack of correct terms. I am using this example to explain
what I am looking to do from a conceptual basis only because of my
newbieness :-)

"a" "Result1" "b" "Final Result"
one onetwo tenfour twoone
two onethree ninetwo twothree
three twoone twoone
twothree twothree
threeone
threetwo

I am dealing with rather large set of terms so I would like to keep the
processes down as much as possible.

Any help with the SQL query code would be a huge help.

Thanks very much.