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<[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
