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

ID	Remarks
CompanyName
fldMemo	This field will be the target - Memo

<tbody>
</tbody>

tblWithKeyWords

idKeyWord
fldCriteria	My criteria - Text field

<tbody>
</tbody>

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