"Christophe Leske" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sorry if this is trivial, but is there no way to do something like: > > insert into idlookup > ( > ( > select * from cl1 > UNION select * from cl2 > UNION select * from cl3 > UNION select * from cl4 > UNION select * from cl5 > ) > where (lomi>13.96 and loma<13.96 and lami>53.23 and lama<53.23) and id > not in (select id from idlookup) > )
Try this: 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); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users