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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-03 : 16:19:21
|
tom nguyen writes "Hi..
I saw your reply to selecting from multiple tables.. but how do I create the results page with the search results?
I have 4 tables that I want to search from with one or multiple keywords:
News (in the news links)
PR (Press releases)
Trade Shows (listing of trade shows)
Website (articles on the web site itself)
If I include a column in each of the databases called "keywords"
I could do a select statement to search all tables..
but how do I display the results of such a select statement in the search results page?
If the record came from News
I want to display the title, date, and link to the news.
If the record came from PR I want to display, title, date, and link to detail page that will display the PR body and other detail columns
If the record came tradeshows I want to display all the records within that tradeshow record..
And finally if it came from the website, I want to display a brief abstract of that article and link to its URL on the website.
I would think this is possible, but its seems to complicated for my blood..
Could you help???
PS. I'm using ASP with SQL 2000 Server" |
|
|
|
|
|
Selecting from multiple tables