On 14 Feb 2017, at 3:55pm, David Raymond <david.raym...@tomtom.com> wrote:
> It's not. It sets up an alias to a new view of test. In the where clause the
> i.whereField is referring to that new view of the whole table, whereas the
> test.whereField is referring to the field in the current record of test
> that's being updated.
Is it a self-JOIN then ? A select where you do something like
SELECT products.id,betterProduct.id FROM products
JOIN products AS betterProduct ON betterProduct.purpose =
product.purpose
WHERE betterProduct.score > product.score
?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
