execution of correlated subquery
475975Jul 11 2006 — edited Jul 12 2006In ordinary subqueries the innermost subquery is executed first completely before the control is transferred to the outer query. but in correlated subqueries , both the inner & outer subqueries are executed simultaneously as they are inter-dependent. What I want to know is that in correlated subqueries is the inner query executed first or the outer one first?
please help me out....
thank you....