jQuery in Action, 3rd edition
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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem in joins" Watch "problem in joins" New topic

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

Joined: Mar 22, 2005
Posts: 42965
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
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
It's not a secret anymore!