aspose file tools*
The moose likes JDBC 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 Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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
Marshal

Joined: Mar 22, 2005
Posts: 42906
    
  69
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