On 10/12/15, R.Smith <rsmith at rsweb.co.za> wrote: > > Two questions - > 1 - would referencing a table alias formed from a table in the same FROM > clause be valid in future? Or is this just for JSON purposes? > > 2 - would this be allowed to reference ANY aliased table, or only one > that can be simplified/factored to an actual table - What rules would > govern such things? >
SQLite has always allowed both. Right? Do you have a counter-example? -- D. Richard Hipp drh at sqlite.org