Dennis Cote schrieb: > Shane Harrelson wrote: > >>> -- a further simplification of the general case that removes >>> -- redundant terms >>> select * from City >>> where id in >>> ( >>> select id from CityLoc >>> where (lat_min < :max_lat and lat_max > :min_lat) >>> and (long_min < :max_long and long_max > :min_long) >>> ) >>> and class <= :max_class >>> order by class >>> limit 20; >>> I need lat and long pos from CityLoc.
I got this currently, sqlite> Select cities.*, citylookup.longitude_min from cities,citylookup where c ities.id in (select id from citylookup where (citylookup.longitude_min>-45.00000 0 and citylookup.longitude_max<45.000000) and (citylookup.latitude_min>-45.11050 2 and citylookup.latitude_max<44.889498)) and cities.class_dds<2 order by class_ dds limit 50; However, this doesn´t give me the city with the longitude and latitude for its position (which i need to position a label). -- 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