hi ,
is it possible to make nested select faster ?

something like this :

SELECT OD.ornumord , OD.ordatord , OD.ortipord , OD.ordescli ,
OD.oridscar , OD.orrifpal , OD.paragsoc
FROM tordmaster OD , torddetaildetail OT
WHERE OD.oridordi = OT.otkeymas
AND OT.otidriga IN
(
SELECT DDD.dv_idord
FROM tdettvend DDD
where DDD.dv__key2 = 1670
)
GROUP BY OD.ornumord , OD.ordatord , OD.ortipord , OD.ordescli ,
OD.oridscar , OD.orrifpal , OD.paragsoc

thanks

Maurizio

Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com