row constructor is not supported yet. a *cheap* workaround is
where orderid+'|'+customerid in(select
orderid+'|'+customerid from orderdetail)
RAC v2.2 & QALite!
"Calvin" <noemailprovided.com> wrote in message
news:OQXc5BsPDHA.1148TK2MSFTNGP11.phx.gbl...> select * from ordermaster where (orderid,customerid) in select
> orderid,customerid from orderdetail
> the sql can't be run in ms sql and is there any similar approach?
> using join will have total # of records returned more than i expected.