I am trying to come up with the syntax to do a full text serach on a field within a table based upon words stored in a field in another table. So I have table on which I want to perform the search. The table contains a text fields called [OutputText] and an [ID] field. Another table contains [SearchWords] and [GroupCode]. I know what the [GroupCode] is and based upon that [GroupCode] I want to find all matching [ID]s.
SELECT [ID] FROM [TOutput] AS TO,
( SELECT [SearchWords] FROM [TWords]
WHERE [GroupCode]=1 ) AS TW
CONTAINS ( [TO].[OutputText],[TW].[SearchWords])
The problem is that the CONTAINS statement will not accept [TW].[SearchWords] as a parameter.
What syntax should I use to accomplish my objective.