posted 18 years ago
Hi All,
I have some problem in executing my nested SQL Statement.
what i want to do is :-
I have 3 tables;
1.Server
2.resource
3.executable.
->server contains:- id and server_name.
->resource contains:- id ,service_id(another table) and resource_name.
->excutable contains :- id,server_id,resource_id,executable_path.
I want to retrive "resource_name".
SQL statement which I write(showing syntax error at "select resource_id from executable... ) is this
select resource_name from resource where id IN (select resource_id from executable where server_id IN (select id from server server_name='qi-125'));
plz help me in solving this ..
Thanx in advance