[sqlite] Fwd: odd schema resulting from creating a table out of a join with a subselect

[Clemens Ladisch]

Hinrichsen, John wrote:
> Could someone point me to documentation on how the schema generation
> works when using a subselect in a join?

<http://www.sqlite.org/c3ref/column_name.html>:
| The name of a result column is the value of the "AS" clause for that
| column, if there is an AS clause. If there is no AS clause then the
| name of the column is unspecified and may change from one release of
| SQLite to the next.


Regards,
Clemens