long select query result as as query string on another select statment

[Madan Thapa]

Hi,


-----------------------------------------------------

(SELECT id FROM domains where name='abc.com');

gives a result of 124


i am also able to use and get proper results for the following query:

select * from domains where id=(SELECT id FROM domains where name='abc.com
');


---------------------------------------------
Now,

select * db_users where db_id=(SELECT id FROM data_bases where
dom_id=(SELECT id FROM domains where name='abc.com'));

Please correct me the syntax for the above command. I am trying to use the
result of one select query as a query string on another.



Thanks