In the Row Values page http://www.sqlite.org/rowvalue.html, section 2.2 there’s
an extra semicolon in the code box, turning it into 2 statements.
UPDATE tab3
SET (a,b,c) = (SELECT x,y,z
FROM tab4
WHERE tab4.w=tab3.d);
WHERE tab3.e BETWEEN 55 AND 66;
(Are miniscule things like that worth pointing out by the way? I just don't
want my OCD to run amok looking for typos that don't really cause confusion or
affect the meaning of something)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
