Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in joins

 
Ahmed Shaikh
Ranch Hand
Posts: 51
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 40
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Very straightforward, four tables, three inner joins.


[ October 21, 2005: Message edited by: Jussi Taimiaho ]
 
Ahmed Shaikh
Ranch Hand
Posts: 51
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanx a lot for your help.
Now its working fine .

Thanx again.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic