On 24-10-2013 21:23, Igor Korot wrote:
Hi, ALL,Will this query work: UPDATE a SET a.field1 = (SELECT b.field1 FROM b AS myfield), a.field2 = myfield... or I will have to repeat subquery for a.field2?
you only have to repeat the subquery if you want the new value of a.field2 to have the return value of a/that subquery....
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users