the given syntax is ANSI sql ("row-value constructors"),
see also the discussion at
http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprecate-update-from.aspxIs it likely that row-value constructors will be implemented in the (near) future ? Jonas Sandman wrote: > On Thu, Aug 20, 2009 at 12:01 PM, Gerald Ebner<geraldo.eb...@gmail.com> wrote: > >> Dear all, >> >> it seems that sqlite does not allow update statements of this kind: >> >> UPDATE table_1 SET (field_a, field_b, field_c, field_d) = ( >> SELECT field_a, field_b, field_c, field_d FROM table_2 WHERE … >> ) >> WHERE .... >> >> > > Is this really proper standard SQL? > > Regards, > Jonas > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
