# 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
