How to tweak hierarchial SQL queries?
From: Bruce Douglas <bruce.douglas_at_bridge.bst.bls.com>
Date: 1995/11/29
Message-ID: <NEWTNews.817690699.11000.bruce_at_ga.bst.bls.com>#1/1
Bruce Douglas -- BellSouth Telecommunications <Bruce.Douglas_at_bridge.bst.bls.com>
Received on Wed Nov 29 1995 - 00:00:00 CET
Date: 1995/11/29
Message-ID: <NEWTNews.817690699.11000.bruce_at_ga.bst.bls.com>#1/1
Arizona
Phoenix
Tempe
Arkansas
Fayetteville
Little Rock
Texarkana
...
I can't get the "states" and "cities" to come back in alphabetical order.
2. Is there a way to sneak past the prohibition against joins with CONNECT BY?
Thanks in advance for your help
Bruce Douglas -- BellSouth Telecommunications <Bruce.Douglas_at_bridge.bst.bls.com>
Received on Wed Nov 29 1995 - 00:00:00 CET