text: There are many methods..\nyou can create a union view , which combines all the different tables that you wanna search into and then make the select statement to the union view..\nother solution , you can make multible select statements, each on a separate table, concatinating the results into your web page.