Does sqlite not support table aliases in update statements? Is there a way
to work around this to get the affect of
update table1 t1
set col1 = col1 * 2
where col1 <= (select avg(col1)
from table1
where col2=t1.col2);
--
Programming today is a race between software engineers striving to build
bigger and better idiot-proof programs, and the Universe trying to produce
bigger and better idiots. So far, the Universe is winning. - Rich Cook
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
