Would like to have a view created to display the result at the bottom of this message.  We will be using Dreamweaver to display the information from this view.  Also, for the record, we are using sql 2000.  Any help would be greatly appreciated.
tblservers
servid    servername
1        server1
2        server2
3        server3
 
tblapplications
appid    appname
1        app1
2        app2
3        app3
 
tblapplink
id    appid    servid
1        1       1
2        1        2
3        1        3
4        2        1
5        2        3
6        3        1
 
we want to display this information as below:
 
appname    serverlist
app1        server1, server2, server3
app2        server1, server3
app3        server1
Thank you very much,
mrtwohttp://www.dbforums.com/showthread.php?p=3710823#post3710823|||Thank you very much!  It works just as we needed it to.  We appreciate you taking time to submit a reply!!
One big frustration down, most likely several more to go!
Thanks again!
mrtwo
 
No comments:
Post a Comment