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