Hello, 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). I tried this: SELECT a.*, b.* FROM a LEFT JOIN b ON (a.term = b.term) But this obviously only fetches all content from a and b where the term occurs in a. Is there any other way than creating temporary tables for this? -- Best regards / Med venlig hilsen Rasmus Christian Kaae - [EMAIL PROTECTED] or [EMAIL PROTECTED] Web: http://kalchas.dk Office: E4-119, Aalborg University. Mobile: +45 28 72 04 13
