This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes problem in joins Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem in joins" Watch "problem in joins" New topic
Author

problem in joins

Ahmed Shaikh
Ranch Hand

Joined: Jul 25, 2005
Posts: 51
Hi All,
Please solve my problem.
I have four tables----->
1.Server >> columns are << id,server_name,ip-address
2.executable >> cloumns are << id,resource_id,server_id,Executablepath
3.resource >> columns are << id,service_id,resource_name
4.Service >> columns are << id,service_name.

Now problem is that I want to retrive service_name where server_name is given.
so please provide me query which will full fill my task.

Thanx in advance.
[ October 21, 2005: Message edited by: Bear Bibeault ]
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42954
    
  73
What does your query look like so far, and what output does it produce? That is to say, what problem are you stuck with exactly?
Jussi Taimiaho
Ranch Hand

Joined: Mar 01, 2004
Posts: 40
Very straightforward, four tables, three inner joins.


[ October 21, 2005: Message edited by: Jussi Taimiaho ]
Ahmed Shaikh
Ranch Hand

Joined: Jul 25, 2005
Posts: 51
Hi,
Thanx a lot for your help.
Now its working fine .

Thanx again.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in joins