wood burning stoves*
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 Murach's Java Servlets and JSP this week in the Servlets 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: 41092
    
  44
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?


Ping & DNS - my free Android networking tools app
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
 
Similar Threads
has anyone encountered this problem when using xpath
Ajax status doesn't stop in IE8
Problem while Tag lib Up gradation
How to Configure SSL over Database in Spring?
Problem in executing SQL statement