Hi, Have you had a look at the EXCEPT statement?
http://www.sqlite.org/lang_select.html (bottom of page) "EXCEPT takes the result of left SELECT after removing the results of the right SELECT. " Does this make sense to you? /Fredrik On Thu, May 6, 2010 at 1:03 PM, Matt Young <youngsan...@gmail.com> wrote: > # I am doing a simulation of distinct > > insert into seriesid (series_id,pointer) > select series_id,ROWID from seriesdata as s > where s.series_id not in( > select > series_id > from > seriesid > ); > > # compile the table seriesid, then in the subquery I interrodate the > table at its current state > # trying to include only members not already in. No run time erros. > > > Is this correct, shouyld this work? > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- "Life is like a trumpet - if you don't put anything into it, you don't get anything out of it." _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users