> insert or ignore into idlookup > select * from ( > select * from cl1 > UNION ALL select * from cl2 > UNION ALL select * from cl3 > UNION ALL select * from cl4 > UNION ALL select * from cl5 > ) > where (lomi>13.96 and loma<13.96 and lami>53.23 and lama<53.23); > Thanks, but sometimes it says "constraint failed"?
What does this mean? 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