> >> If you want columns to have names, create a TABLE or VIEW, > >> and specify what those names should be using "AS".
> > You would define the column names in the definition of the table or the > > view. There would not be any AS clauses (they will not work). > Sorry, I meant that the "AS" clauses would be in the SELECT command which > consulted the TABLE or VIEW, or could be in the SELECT command which was > in the VIEW. I can't visualize what you mean. Something like: create view constants (col1, col2) as values (1,1), (1,2); seems the most straightforward to me, and allows you to assign column names to the data. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users