On 14 Feb 2017, at 3:36pm, James K. Lowden <jklow...@schemamania.org> wrote:
> UPDATE test > SET value = value + 100 * ( > SELECT min(i.value) -- or max, or something > FROM test i > WHERE i.whereField = test.whereField > ); Someone please explain something to me ? One of my assumptions is wrong. The construction "FROM test i" is a short form of "FROM test AS i". This sets up an alias to the table "test" so you can call it "i" if you want to. Later on in that command I see "WHERE i.whereField = test.whereField". Under the circumstances is that not the same as "WHERE test.whereField = test.whereField" ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
