"Dusan Gibarac" <dgiba...@cbsits.com> wrote in message news:4951940f....@cbsits.com > There are tables t1( f11, f12) and table t2(f21, f22) and one > has to update field t1.f12 with values t2.f22 where t1.f11 = t2.f21.
update t1 set f12 = (select f22 from t2 where f11 = f21); Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
