Create a new table with the results of a query that uses multiples criterias from 2 different tables

[Luthius]

Guys

I have one table that contains a memo field (tblWithMemoField)
The second table has some keywords (tblWithKeyWords)

What I want to do is a query that can generate a table using the field fldCriteria(tblWithKeyWords) to find the records from the tblWithMemoField on field (fldMemo).
There is no relationship between the tables.


tblWithMemoField
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]CompanyName[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fldMemo[/TD]
[TD]This field will be the target - Memo[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]







tblWithKeyWords
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]idKeyWord[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]fldCriteria[/TD]
[TD]My criteria - Text field[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]






Would be something literally like below - Of course the statement below doesn't work.

[COLOR=#008000][FONT='inherit'][B]SELECT [/B][/FONT][/COLOR][COLOR=#333333][FONT='inherit']CompanyName [/FONT][/COLOR][COLOR=#008000][B]FROM[/B][/COLOR] tblWithMemoField [COLOR=#008000][FONT='inherit'][B]WHERE[/B][/FONT][/COLOR][COLOR=#333333][FONT='inherit']((([/FONT][/COLOR][COLOR=#333333][FONT='inherit']fldMemo[/FONT][/COLOR][COLOR=#333333][FONT='inherit'])[/FONT][/COLOR][COLOR=#008000][FONT='inherit'][B]LIKE[/B][/FONT][/COLOR][COLOR=#19177C][FONT='inherit']"*"[/FONT][/COLOR][COLOR=#666666][FONT='inherit']+[/FONT][/COLOR][COLOR=#333333][FONT='inherit'][[/FONT][/COLOR][COLOR=#333333][FONT='inherit']tblWithKeyWords[/FONT][/COLOR][COLOR=#333333][FONT='inherit']][/FONT][/COLOR][COLOR=#666666][FONT='inherit']![/FONT][/COLOR][COLOR=#333333][FONT='inherit'][[/FONT][/COLOR][COLOR=#333333][FONT='inherit']fldCriteria[/FONT][/COLOR][COLOR=#333333][FONT='inherit']][/FONT][/COLOR][COLOR=#666666][FONT='inherit']+[/FONT][/COLOR][COLOR=#19177C][FONT='inherit']"*"[/FONT][/COLOR][COLOR=#333333][FONT='inherit']));[/FONT][/COLOR]

How can I do it?

Luthius