Re: [sqlite] Merging to tables

[Eric Bohlman]

Rasmus Christian Kaae wrote:
I was wondering if there was some way of merging to tables *fast* for querying?
I have the following schemas:
CREATE TABLE a (term text, location blob);
CREATE TABLE b (term text, location blob);

What I would like to do is to iterate through *all* records in a and b sorted by
term (records from a and b should be interleaved if necessary).

SELECT term,location FROM a UNION ALL SELECT term,location FROM b ORDER 
BY term;