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