On 25 Aug 2015, at 6:52pm, sqlite-mail <sqlite-mail at dev.dadbiz.es> wrote:
> I can understand your point, what confuses me is that when we query a view > with "a.*" it doesn't qualify the names so I thought that was a mistake when > we use individual names otherwise I would expected qualified names there too. I understand that this is not what one would expect. Worse still, as the documentation says ... <https://www.sqlite.org/c3ref/column_name.html> "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." If you expect your own code to know what columns are called use 'AS' for each column. Simon.
