Re: [sqlite] table.* excludes ID field when using natural join ?

Samuel R. Neff wrote: I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for

[sqlite] table.* excludes ID field when using natural join ?

I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> create