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-04 : 17:19:49
|
Juan Villarreal writes "Hello, Team.
I wonder if would you mind help me with this doubt? , please.
I have a table with recursive relation ship. one field called subkey, has the value that contains the value of the main key and I need to obtain the value of a subquery for each record, if it's not clear, let me show you with data:
I have this information:
key Description subkey
---- ------------- ---------
1 One 1
2 Two 2
3 Three 3
4 Four 1
5 Five 3
6 Six 6
7 Seven 5
And i need this information:
key Description subkey Description_Subkey
---- ------------- --------- ------------------
1 One 1 One
2 Two 2 Two
3 Three 3 Tree
4 Four 1 One
5 Five 3 Three
6 Six 6 Six
7 Seven 5 Five
I hope you can help me, thanks for your time.
Bythe way, I using SQL SERVER 7.0
Thankx alot." |
|
|
|
|
|
Doubt!!!