• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in joins

 
Ahmed Shaikh
Ranch Hand
Posts: 51
  • 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
Posts: 42968
73
  • 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
  • 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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Thanx a lot for your help.
Now its working fine .

Thanx again.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic