File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Regarding join statement? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Regarding join statement?" Watch "Regarding join statement?" New topic

Regarding join statement?

vijay mahendra
Ranch Hand

Joined: Jan 01, 2007
Posts: 51
Hi one and all,

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.
Satish SN
Ranch Hand

Joined: Apr 19, 2005
Posts: 70
Hi Vijay,

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

Satish SN<br />SCJP 1.4 & SCWCD 1.4
I agree. Here's the link:
subject: Regarding join statement?
jQuery in Action, 3rd edition