thanks a lot to tom(link helped me) and others who send the responses .
when joins are there, how subqueries help us?
want to know whether outer query executed first or inner query executed first? how the following query is executing and giving some result. when i tried in similar manner getting exception like "too many rows selected..."
Joined: Jun 22, 2010
How to identify which is a subquery and which is correlate subquery?i understand the difference between correlated subquery and subquery
(got information like subqeury executed only one and correlated subquery executes several times)