GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Comparing two query results

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

    Matt

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

    Comment

    Working...
    X