At 18:18 04/06/2016, you wrote:
Hi,
why? At the moment I have to run something like:
UPDATE A SET item1=(SELECT B.item FROM B WHERE B.ID=A.ID),...
itemN=... WHERE EXISTS (SELECT 1 FROM B WHERE B.ID=A.ID);
Using a FROM clause I just need one scan through B (at least in
principle). Now, I need N+1 scans.
Regards,
Hartwig
Can't the same update be done more efficiently with a CTE?
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users