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