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 id

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

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 > >

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