Clemens Ladisch wrote: > > Your query did not involve the query flattener. Try this: >
I used the query as originally reported. However, as others have stated, without AS clauses, the column names are not well-defined. In this case, the IDataRecord.GetName method of the SQLiteDataReader class is a very thin wrapper around the underlying sqlite3_column_name() API. Basically, it just returns whatever the sqlite3_column_name() API returns verbatim. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users