Comparing two query results

Hey Guys!

My first time here so hello all and thanks in advance for any help you may be able to give me.

I have a table called links with the following structure:

| link_id | type | frequency |

The type can be either link or advert.

I also have a table called links to keywords with the following structure:

| s_link_id | d_key_id |

I have a query that finds the most popular keywords by finding the keywords associated with the most frequently viewed links of type link.
I’m now trying to find the links of type advert that have keywords associated with them that match most closely the keywords of the links.

Any ideas how this can be achieved?

Ive tried the Like expression, but if the keywords associated with each type of link dont match exactlty then it doesnt return any results.

Thanks guys, I hope this makes sense!


Joins are based on exact match, so if you need fuzzy match you’re going to need something like a table of synonyms.