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

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 ');

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

what is the issue ur facing. Any syntax error or something else. trying usin IN instead of = On 9/26/08, Madan Thapa [EMAIL PROTECTED] wrote: Hi, - (SELECT id FROM domains where name='abc.com'); gives a result of 124 i am also able

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

-- --- (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 ');

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

Hi, ok i got it working. it was a typo(lol), i missed from in the initial select statment Wrong ### select * db_users where db_id=(SELECT id FROM data_bases where dom_id=(SELECT id FROM domains where name='abc.com')); Correct ## select * from db_users where db_id=(SELECT