Multiple Tables

[LeaderOne]

Hi!

i'm having a proble with regards to my search.:(

i want to search multiple tables using a keyword.

those tables doesn't have relationship or doesn't have similarities...how can i perform my search?

thanks in advance.

i'm using SQL Server 2005 :)

[GJay]

some more information would help (the columns in the tables, and then which ones you want to search), if the tables aren't in anyway connected, why are you wanting to search them as if they were?

[LeaderOne]

i'm creating a page on which a user can search using a keyword anywhere in the database.

The thins is i wasn't the one who designed the database. If i we're going to re design the database, it will take time, and i doesn't have that much.


thanks for your reply.

[GJay]

That's just silly. Why would a user want to search for something anywhere in the database, and more to the point, why would you want to let them?