Just out of curiosity, where in the syntax documentation does it mention "selected from"?
On Wed, Jun 10, 2009 at 10:57 AM, Igor Tandetnik <itandet...@mvps.org>wrote: > Rand Huck wrote: > > In addition to what was already said, if you absolutely to omit the > > 'name' from the final result set, you should be able to put the > > result of the union in a temporary table. > > Or else add an extra layer of indirection: > > select id, url, selected from ( > SELECT id, url, selected, name FROM db1.test UNION > SELECT id, url, selected, name FROM db2.test > ORDER BY name ASC, id DESC LIMIT 100 > ); > > This essentially instructs SQLite to create a temporary table for the > duration of this statemet (also known as ephemeral tables). > > Igor Tandetnik > > > > _______________________________________________ > 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