Re: [sqlite] Aliases in subqueries?

2010-04-02 Thread Igor Tandetnik
Fredrik Karlsson wrote: Sorry for asking this SQL question, but I just have to make sure: - Aliases in subqueries - are the always, local to the scope of the subquery? That is, if I have this query (this example makes _no_ sense, I know. Just an illustration.): select target.* from

Re: [sqlite] Aliases in subqueries?

2010-04-02 Thread Fredrik Karlsson
On Fri, Apr 2, 2010 at 1:59 PM, Igor Tandetnik itandet...@mvps.org wrote: Fredrik Karlsson wrote: Sorry for asking this SQL question, but I just have to make sure: -  Aliases in subqueries - are the always, local to the scope of the subquery? That is, if I have this query (this example