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 ]