I am building a "tree view" and I need to be able to display the information in a specific way. Let's say my data looks like this:
(imagine this as a two column database)
But i need to display it like this:
What is the best way to do this? I don't think that this is too easy in SQL so I am trying to figure out how to do a loop in my servlet to build this. Do I write a loop with a conditional of some kind?
I am thinking this has a simple solution but I am not seeing it.