Full text search on multiple fields in different tables

Question

Hi,

I want to create a a full text search usng ms sql 2005.

here is the structure of my table User-contains fields of Id, fname,lname,email,alternativeemail

Attachment-contains fields of id, name,category,filenameorurl Certification-contains of fileds of id, title,school,sdate,edate EducationalBackground-contain of fields of, id,qualification,sdate,edate,school,fieldofstudy EmploymentDetails-contain of fields position, positionlevelid,specializationid,description

now the relationship of user to the other table is one to many relationship.

now how can I create an effective query to have quick full text search and return the values of the different tables?any help please

Answer 1

• Understanding Full Text Search in SQL Server 2005
• SQL Server 2005 Full-Text Search Indexing
• Using SQL Server 2005 fulltext search from ASP.NET 2.0
• Additional help