"Using WITH to factor out a non-correlated subquery, as demonstrated in the preceding section, is relatively easy. Factoring out a correlated subquery requires more thought beause WITH subqueries cannot be correlated. Consider the following query, which uses a correlated subquery to return the country name for each attraction:"
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
branchandroot
no subject
Date: 2006-08-02 09:13 pm (UTC)