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