Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Yikes - Need help

Author  Topic 

edb2003
Yak Posting Veteran

66 Posts

Posted - 2003-08-07 : 18:13:55
Hello everyone,
I have 3 different tables ... a, b, c
I have 3 different seach asp pages a.asp, b.asp, c.asp
from MasterPage.asp.

search a.asp does a search between tables a and c and does a post.
search b.asp does a search between tables a and b and does a post.
search c.asp does a search only in table a.

How can I make 1 search page to do all 3?
Please Help :)

thx,
Edb

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-08-07 : 18:19:53
You haven't provided enough information. Do you want to know how to write the T-SQL or the asp? What do your tables look like (post DDL and not just columns name)? What does the data look like (post INSERT statements for us please)? Do you want 3 different queries on the page or one query that searches all of the tables?

Tara
Go to Top of Page
   

- Advertisement -