how to write many keyword like expression in different tables

[muwsa]

hello,
please help me, i have spent my time to try to solved this problem but its hard for me.

I have 2 tables. Tables A fills certain merchant's name and its address in 1 field.

Table B fills many keyword of merchant' name without its address.

Question: what should i write like expression to connect 2 tables, so that i can have a certain merchant's name (tables A) from keywords of merchant's name in table B??



Please help,
than you so much for your attention...

[pbaldy]

I don't really understand what you're trying to do, and given the length of time this has gone unanswered I suspect others are in the same boat. Can you perhaps show some sample data and the expected result?