> Perhaps something like this: > > select * from > (select * from c1 > union all > select * from c2 > union all > select * from c3 > ... > ) > where foo1 < 10; > Yes!
And to answer MikeĀ“s email as well: these table represent higher and detailled data for deeper research, so all of these tables have the same data c1 to c5 are in fact rtree tables for different classes of cities. Depending on the distance from the viewer onto a 3d globe, i want just to show the capitales, then the capitales and the big cities (c2), then the capitales (c1), the big cities (c2) and the not so big cities (c3) and so forth. Since it is depending on the distance from the ground and the rtree table only works with coordinates, i cannot really include the class-attribute into the rtree, hence several rtrees. -- 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