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.
posted 9 years ago
Your requirement is not clear from what you have written.
Basically the joins in SQL are used to retrieve data from multiple tables based on common condition.
In your case the browser code and names are stored in two tables that is a bad database design they way you have explained in your problem.
if you could put couple of records from both the tables i can help further in solving your problem