Full Text Index in SQL Server 7

[MarcelB]

Hi all!

I have to build this search page for this website I'm working on. I have multiple fields in multiple tables that I want to search through. All tables and fields have been enabled for full text index search.

Is there a way I can search all those fields in all those tables in 1 query? If so, how?

If not, then I thought of another way to do it, namely search the different tables in some sort of loop-structure, and then just add the results to an overall result recordset. So I've been wrestling with this idea, but I can't seem to get it to work.

Any help would be highly appreciated.

Thanx, Marcel

I'm not sure if this is the good way (depends on the amount of data you have) but you could throw everything in a view and query that?

Would that keep the full text index search possibilities then on all different tables?