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-10-12 : 10:44:59
|
David writes "Using SQLServer 2000Not entirely sure how to approach this problem, I was wondering if a back join would work but you may have a better idea...Below is an example table of data:BLOCK_ID VALUE INCLUDE_BLOCK_ID------------------------------------------- 1 a NULL 1 b NULL 1 c NULL 1 d NULL 1 e NULL 2 f NULL 2 NULL 1 2 g NULL 2 NULL 3 3 h NULL 3 i NULL 3 j NULL 3 k NULL What I am trying to do is a query which will return a recordset for block_id 2 which also inserts into the recordset the included blocks in the correct place were specified within block_id 2.Any ideas?ThanksDavid" |
|
|
|
|
|
SQLServer Back Join