On 3/9/2016 10:39 AM, Jean-Christophe Deschamps wrote: > Of course I use correlated subqueries a lot, but never had to re-select > a column from the enclosing query. Indeed, I'd say that most of the time > one uses columns from enclosing query as expressions, e.g. in comparison > operators or functions in a where clause.
Things that appear in the list after SELECT are also expressions, no different from those that appear in WHERE clause or elsewhere. -- Igor Tandetnik