I have a database that is far from being rational! I need to query the tables to get a hierarchy resultset.
Here is the structure:
levelOne
levelOne_A
levelTwo
levelThree
levelFour
my problem is that table levelOne_A and table levelTwo have data that are considered to fall underneath levelOne. However the data is far different from each other so I can not able merge both into one.
so the it should look like this:
levelOne
levelOne_A AND levelTwo
levelThree
levelFour
Any ideas how I can get my hierarchy structure?
Thanks for your help!
Sunday, February 19, 2012
Help me create a SQL Statement
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment