Freetext / Freetexttable on multiple tables

Hi,

I realised that I am not able to do a FREETEXT search on multiple table, example:

SELECT * FROM [tStaffDir], [tStaffDir_ClientExp], [tStaffDir_CoreSpecs], [tStaffDir_GlobalExp], [tStaffDir_Lang], [tStaffDir_PrevEmp], [tStaffDir_TerEdu] WHERE FREETEXT(*, @.Name) ORDER BY [Name]

Can I use FREETEXTTABLE instead? How do I go about doing it?

Check out this link:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20880133.html

For more details about FREETEXT: http://technet.microsoft.com/en-us/library/ms176078.aspx

Good luck.

|||

Hi,

Thanks for the link. But I do not wish to subscribe tohttp://www.experts-exchange.com even though they offer a 7-day free trial.

Will appreciate if the solution/hint can be shown on this forum instead so that others can benefit from it too.

Many Thanks.