In the C interface documentation we are told: "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."
What exactly is meant by 'unspecified'? Does it mean that in the absence of an "AS" clause I will get either TABLE.COLUMN or COLUMN, or are there/may there be other alternatives? I've just discovered I can get COLUMN for some names and TABLE.COLUMN for others depending (apparently) on how many tables I have JOIN'ed in the query. Pete -- Peter Hardman 'For every complex problem there is a solution that is simple, straightforward - and wrong' _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
