Table A has columns
question varchar(200) objective varchar(200)
Table B has columns + a fulltext index
solution varchar(max)
I am trying to output a flat merge of these matching a.objective with the TOP 5 solutions from Table B for the keywords in A.objective.
where freetext(text,A.objective)
e.g. "question one", "objective one", "best solution one" "question one", "objective one", "best solution two" "question one", "objective one", "best solution three" "question one", "objective one", "best solution four" "question one", "objective one", "best solution five" "question two", "objective two", "best solution one" "question two", "objective two", "best solution two" "question two", "objective two", "best solution three" "question two", "objective two", "best solution four" "question two", "objective two", "best solution five"
Not sure how to write this query.