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 - 2000-12-07 : 17:32:10
|
mel abutin writes "How do you select data from multiple tables,
sort the whole selected data alphabetically
using a field present in all tables as the 'order by'
clause and display them in html-ASP as one table
(ex. < % =rs("artist_name") %>
< %=rs("album") % >
Assumptions
*all tables have the same set of fields, just different data.
*the SQL statement is incorporated in a search engine coded in ASP-HTML
I'm using IIS, ASP, HTML, SQL Server 7.0
that's all. thanks!"" |
|
|
|
|
|
SQL for multiple tables and an order by using a field present in all tables