You should be able to craft the query outside of the database and then treat it like a normal query. You have to be very careful about doing this, and it generally isn't a good idea. If you do take this approach, make sure that you properly sanitize the column names, especially if they are provided by users.
On Mon, Jul 29, 2013 at 7:32 PM, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > Dear SQLiters, > > I think the answer to my question is "NO", but may be I missed something... > > Can column name come from a table, i.e. from another select? Example: > > SELECT (SELECT columnName FROM columnNameTable WHERE condition how to select > limit 1) > FROM table which has that columnName; > > Or this is not doable within SQL and I must execute internal select > separately and have application compose second (external) select? > > Thank you, > > Roman > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
