File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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: 42955
    
  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