Fulltext Search over multiple table of the same structure

[Rado]

Hi Everybody,

I'm interested to add the fulltext search feature on a portal that i administrate.
The portal stores data of several online shops. Each shop has its own PRODUCT table where are stored the offered products. The structure of the PRODUCT tables for all of the shops is absolutely the same.

My question is:

Is there possibility to do fulltext search over multiple tables while each of the table is a separate entity?

Thanks for your replies

Rado



Edited 1 time(s). Last edit at 10/12/2005 02:22AM by Rado .