I need somedata in my project that was related to 2 tables. But problem was ,we have 2 tables , one is codes and other is name.
but i need to display on browser names corresponding to code as tree structure. but i wrote a join query ,it returns all the codes and names .
and i tried add those details to tree structure. But it displays as all the codes in table as parent nodes and all the names as child nodes. But i need to display as child names those are corresponding to code as parent only .
Hot to write this join . ??? in resultset, we should get only names related to code. plzzz give suggestions if any.