maruf24 (7/30/2008)
select alias.id,alias.aaa,alias.colname,table1.id,table1.ttt,table1.c_f_name,cy.cmd from table3 alias,
cm table1,table2 cy where alias.colname=table1.colname
and cy.colname = table1.colname and table1.id='354'and
alias.colname in (select colname from table2 where colname
like '365464') and colname='A' and colname =123)
i may be wrong ... but still 2 cents
cant u take away the "in" part and replace it with
colname = '365464'. Another thing using like is also going to return one record.
"Keep Trying"