Note to self: Do not ask questions before I finish my coffee. ;) On Wed, Jun 10, 2009 at 11:27 AM, Pavel Ivanov <[email protected]> wrote:
> It mentions "from" and "column_name" where column name in this > particular case is "selected". ;-) > > @Igor: I thought that sql standard in this case doesn't guarantee that > outer select will return rows in the same order that were enforced in > inner select by "order by", does it? > > Pavel > > On Wed, Jun 10, 2009 at 11:15 AM, Rand Huck<[email protected]> wrote: > > 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 <[email protected] > >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 > >> [email protected] > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
