In the Row Values page, 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

Reply via email to