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 - 2005-01-17 : 10:03:16
|
| kunwar bahadur singh writes "suppose there is one tabale country(state,district,city,colony)now i wants to wriet a select query such that it display the resukt in the fallowing form State First District first city first colony first colony second .. District Second city first colony first colony second ..... State Second District first city first colony first colony second .. District Second city first colony first colony second ....." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-01-17 : 10:08:18
|
i'm sensing a cross join in there somewhere...any words of wisdom, dr. Cross Join?Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Query