> When you add multiple tables into the FROM clause, you make a single > conceptual table out of them by using the JOIN operator. So
(with c1,c2,c3 all being rtrees) select * from (select * from c1,c2,c3) where bla>10 is *not the same as select * from c1 where bla>10 union all select * from c2 where bla>10 union all select * from c3 where bla>10 ... > If you want the same query out of a number of different tables that > are identical, and join the results together, then you use the UNION > clause... in other words, you do indeed perform the SELECTs separately > and then UNION them together, but you have to apply the WHERE > constraint only once because all the tables are identical. > Do you mind elaborating on this point? Is that what Igor wrote me? Christophe Leske www.multimedial.de - [EMAIL PROTECTED] http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users