Re: dependent subquery/correlated subquery

2005-04-19 Thread SGreen
James Nobis <[EMAIL PROTECTED]> wrote on 04/19/2005 04:04:24 PM: > The link below essentially means subquery support is useless for many > traditional purposes. You are stuck in a correlated subquery thus performance > is the query being run out-to-in (subquery run for every row?) instead of >

dependent subquery/correlated subquery

2005-04-19 Thread James Nobis
The link below essentially means subquery support is useless for many traditional purposes. You are stuck in a correlated subquery thus performance is the query being run out-to-in (subquery run for every row?) instead of in-to-out as desired. Does anyone know of a work around for this? Apparant