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-01-25 : 11:59:56
|
Ty writes "In my query, which runs from an ASP page, I need to select the Notes field from 2 different tables
(i.e. SELECT....contacts.notes, visit.notes....FROM...)
and return them to be displayed in the page. My query runs fine, but I cannot figure out how to display the different fields. For instance, my recordset is set to "rs", so I would write response.write rs("myrecord"). However, I can't find a way to specify which notes field is displayed. Using rs("visits.notes") only gives an error, (as does every combination I could think of.)
Is there a way to specify which of the recoreds is accessed without having to use multiple queries?" |
|
|
|
|
|
Query where different tables have like column names.