Post reply

Full text search involving 2 tables

  • April 20, 2010 at 8:48 am

    #144124

    Hi, I'm very noob in relation to Full Text search and I was told to do a full text search over 2 tables and sort results by relevance.

    I will look on table "Posts" and table "PostComments". I must look for the search term (let's say "AnyWord") on Posts.Description, Posts.Title and PostComments.Comments.

    I have to return Posts order by relevance but since I'm looking on Posts AND PostComments I don't know if this make sense. I'd say I need all the information on the same table in order to sort by relevance.

    Could you help me to figure out if this make sense and if it does how to achieve it?

    Thanks in advance

  • April 21, 2010 at 11:32 am

    #1155551

    See

    http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic10317.aspx

  • April 21, 2010 at 7:37 pm

    #1155808

    Thanks dmoldovan! I'll take a look to that

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply